Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have create a master calendar using the below script :-
MasterCalendar:
LOAD TempDate AS date_time,
Date(Monthstart([TempDate]), 'YY MMM') as YearMonth,
MY AS MonthYear,
D AS Day,
M AS Month,
Y AS year
RESIDENT TempCalendar
ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
My issue is YearMonth field does not recode the date_time only the first row , and give the rest of the row missing value , where i make the mistake ?
Paul
Hi Paul, all your rows in master calendar has his YearMnoth field with value.
Problem is you are getting date and time in your date_time field, so master calendar only has values for each day at 3:28:23 PM, other "times" in the same date has no relation with master calendar.
So you need to link with master calendar only with date, no time, and it should work
Hi Paul, all your rows in master calendar has his YearMnoth field with value.
Problem is you are getting date and time in your date_time field, so master calendar only has values for each day at 3:28:23 PM, other "times" in the same date has no relation with master calendar.
So you need to link with master calendar only with date, no time, and it should work
You have use only field date format or number, without time.
Best Regards.
Tonial.
Hi Ruben
Now working fine , after i convert field which have date and time into month and year , now working fine.
Paul