|
I created a crosstab report with a date function (thanks to this forum) based on our pay periods. and it runs automatically. Only have to change it at the end of every fiscal year. But just got a call that when the leap day happened it threw the reports off by one day. Here is the formula I use.
ceiling(datediff('d',date(2015,6,27),{TPB105_CHARGE_DETAIL.chg_srv_ts}),14)/14
I don't know how to figure in that day without throwing off the beginning of the report. do just create a whole new report starting from the period with the leap day?
|