Hi I have a Field in my data that is populated by Jan 18, as the Month and Year.
Is there any way to convert it into 'yyyy MM dd' ?
I have looked at inline tables but there are to many variables.
Hello, maybe this in the script:
Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY.MM.DD') AS YourDateField
Also, look at these threads
Why don’t my dates work?
Get the Dates Right
Try Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY-MM-DD')
Thanks Ivan, that worked
Retrieving data ...