A bit more info...when I execute the proc in SSMS it is returning that 2/29 perf. So it must be something in Infomaker?
Hello All,
I have a custom report that is not returning the perfs for 2/29/16 and I think it is because it is a leap year. I have found articles online that talk about creating a leap year function to test if it is a leap year. I've also read that maybe it is caused by the datetime data type. The custom report is pulling data from t_imp_perf_data where the perf date is a datetime type. Anyone have any ideas?
Gloria
How are the parameters to run the report set up? Is there a date range? Is the EOD box checked on the end-date parameter if so?