This content has been marked as final. Show 3 replies
Day(New_Date) as tmp_day
Day([To Date]) as tmp_day2,
LOAD [Loading Date],
Date#([To Date]) as New_Date,
(txt, utf8, embedded labels, delimiter is ',', msq)
// where match(Day([To Date]),28,29,30,31)
I am unable to extract day from the date field. I tried typecasting the field and converting it to a set date format but no luck.
Would be really helpful if someone can look at this issue.
I have attached the calendar csv I am using to pull the dates from.