Hello,
I am pulling data from a SQL server and having issues with my date. I would like Day, Month, Month Year and Year pulled out as separate fields. I tried with Month Year first. If anything a master calendar? The Chart below is showing days when I thought it would show month year?
[table1]:
LOAD
.....
// [date_started],
Date(MonthStart(Date#(SubField([date_started], ' ', 1), 'YYYY-MM-DD')), 'MMM YYYY') as MonthYear,
....
SELECT "audit_id",
....
"date_started",
FROM .....
![wgoudeau_0-1644856952636.png wgoudeau_0-1644856952636.png](/t5/image/serverpage/image-id/72254i9CF672D2EA4CB62B/image-size/medium?v=v2&px=400)
Original date time before I tried to convert it :
![wgoudeau_1-1644856995999.png wgoudeau_1-1644856995999.png](/t5/image/serverpage/image-id/72255i4FB12D764C961BF3/image-size/medium?v=v2&px=400)