Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can we create date from year and quarter field
this give wrong result pfa
Hi,
Try like this
LOAD *,
MakeDate(Year, Quarter*3) AS Date
INLINE [
Year, Quarter
2015, 1
2015, 2
2015, 3
2015, 4
];
Regards,
Jagan.
Looks correct
Which result did you expect?
Regards
Marco
Well its the correct result if you want the first day of each quarter. So what date do you want?
I want all the month
Hi Try this Script:
MasterCalendar:
LOAD
Date AS CreatedDate,
Month(Date) AS CalendarMonth,
Year(Date) AS CalendarYear,
'Q'&ceil(Month(Date)/3) AS Quarters,
Month(Date) & '-' & Year(Date) AS CalendarMonthAndYear;
LOAD
Date(makedate(2015,1,1)+recno()-1,'DD/MM/YYYY') as Date
Autogenerate makedate(2015,12,31) - makedate(2015,1,1) + 1;
Hope that helps.
Regards
Av7en
Hi Swetha,
Try this script below
LOAD *,
MakeDate(Year, Quarter*3) AS Date,
SubField(Quarter*3 & '/' & (Quarter*3 - 1) & '/' & (Quarter*3 - 2), '/') AS Month
INLINE [
Year, Quarter
2015, 1
2015, 2
2015, 3
2015, 4
];
Regards,
Jagan.