LoriDurham
MIS
WHERE DATE(LPAY.ADDED_DT) between date( '07' || '-' || '01' || '-' || CHAR(YEAR(current date )))
and (((DATE(current date) - Day(DATE(current date)) day)+1 day)) - 1 day
Above is my where clause which works fine, I alwuas wants to get data from July to June and chnages next year
But problem here is after December year will change to 2010,
can i write a case statement in a way that year will only increment after june(fiscal year time period)?
Thanks so much
and (((DATE(current date) - Day(DATE(current date)) day)+1 day)) - 1 day
Above is my where clause which works fine, I alwuas wants to get data from July to June and chnages next year
But problem here is after December year will change to 2010,
can i write a case statement in a way that year will only increment after june(fiscal year time period)?
Thanks so much