This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, I’ve imported a field from excel containing dates in the formate 2020-03-14 22:38:39 UTC
I’m trying to customize the field into Date in order for me to Group the dates by Year and Month.
But if I run the standard operation the field returns empty...
Thank you I actual managed to use DATETIME_FORMAT successfully for this task. And then convert the field to date type.
Your help is much appreciated @kuovonne
Hi @kuovonne
Thank you for the reply,
Yes I tried to customize the field type to a date field but then all my data is erased from that field.
Would I use DATETIME_PARSE(date, [‘input format’], [‘locale’]) ?
