neerajthakur
Creator III
2021-11-01
09:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Adding Fiscal Year and Quarter to existing Calendar
MasterCalendar:
Load
TempDate AS CreatedOn,
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
Day(TempDate) As Day,
'Q' & ceil(month(TempDate) / 3) AS Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
;
//=== Generate a temp table of dates ===
LOAD
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate;
//=== Get min/max dates from Field ===/
LOAD
min(FieldValue('CreatedOn', recno()))-1 as mindate,
max(FieldValue('CreatedOn', recno())) as maxdate
AUTOGENERATE FieldValueCount('CreatedOn');
Hi, what changes can be made to above code to add Fiscal Year and Quarter into this.
Thanks & Regards,
Please Accepts as Solution if it solves your query.
Please Accepts as Solution if it solves your query.
290 Views
0 Replies