Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Calendar table which each Fiscal Year/Period is linked to a date range. For example, Fiscal Year / period 2019002 has dates range from January 29th 2018 to March 4th 2018. I want to create a table with only the date end of each Fiscal Year Period. Is there a way to use Where to extract those dates ? Thank you for your help.
LOAD Date_DATE0,
[Fiscal year / period_FISCPER]
FROM
(qvd)
Where ;
Perhaps like this:
LOAD
[Fiscal year / period_FISCPER],
Date(Max(Date_DATE0)) as Date_DATE0
FROM
(qvd)
GROUP BY
[Fiscal year / period_FISCPER]
;
Please send a sample data
Perhaps like this:
LOAD
[Fiscal year / period_FISCPER],
Date(Max(Date_DATE0)) as Date_DATE0
FROM
(qvd)
GROUP BY
[Fiscal year / period_FISCPER]
;
Thank you very much Gysbert.