topic Re: Generate List of End Dates in App Development

Generate List of End Dates

Anonymous — Wed, 07 Mar 2018 16:06:14 GMT

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 ;

Re: Generate List of End Dates

ziadm — Wed, 07 Mar 2018 16:31:40 GMT

Please send a sample data

Re: Generate List of End Dates

Gysbert_Wassenaar — Wed, 07 Mar 2018 16:32:57 GMT

Perhaps like this:

LOAD

[Fiscal year / period_FISCPER],

Date(Max(Date_DATE0)) as Date_DATE0

FROM

(qvd)

GROUP BY

[Fiscal year / period_FISCPER]

;

Re: Generate List of End Dates

Anonymous — Thu, 08 Mar 2018 23:45:45 GMT

Thank you very much Gysbert.