Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a version of some script to generate a calendar table to include such values like the calendar year etc... This run based on peeking at a dataset and capturing the the min and max dates.
However I am not certain how to generate the following, and was hoping someone might have a solution:
If anyone can point me in the right direction it would be much appreciated.
Thanks
Matt
Hi Matt,
Please go through the Date_Time Functions in the help. Once you have a date, formatting could be done using the date() funtion. For the Month/Quarter numbers, there are functions, and You could also use a simple inline table like:
Load * Inline [
Month, Quarter, MonthNo,QuarterNo, FiscalMonthNo,FiscalQuarterNo
Jan, Q1,1,1,10,4 // In case fiscal year starts in April, Jan will be 10th month, falling in 4th quarter
.
.
.
.