hi all,
I have the date field, but CRMA provides the format I need to change
YYYY-mm-DD -> mm-DD-YYYY
I tried to change it via formula field in advanced editor:
"formula": "toDate(Booked_Date__c, \"mm/dd/yyyy\")"
but as a result an error:
Field must be in group by or aggregate function:
can somebody suggest something maybe, please?
3 answers
If you want to change the date format wherever you're using the field, you can change the format in the fields panel. To get there, open the dataset in a lens and find the small arrow right next to the dataset name.
If you're creating the dataset with a recipe, you can use the "edit attributes" transformation to change the date format.
How about creating the date in your desired format in a recipe, as text?
