Forum Discussion
Date format issue
Hi, I hope some experts help me with a date format issue. The format of my date column on the data source, an excel file, is Q1 20/21, Q2 20/21, Q3 20/21, Q4 20/21, Q1 21/22..... So when I import...
Qmars007 ,
Based on Month start date , create a date , Assume FY start from Jan
Date = Eomonth(date(mid([FY Qtr],4,2), 4,1) , (mid([FY Qtr],1,1)-1)*3 )
Then you can use time intelligence