Hello guys,
I am an extreme beginner,
I have my data as a date in the incorrect format, I'm looking to auto-convert each figure into a specific "date" category.
Can someone please explain how to do so?
Thank you so much in advance
Page 1 / 1
You'll need to use a formual field with `DATETIME_PARSE()` and the correct format specifiers.
Here's something to start you off:
Formula:
IF(
AND(
Date, Year
),
DATETIME_PARSE(
Date & " " & Year,
"MMM D YYYY"
)
)
You'll need to use a formual field with `DATETIME_PARSE()` and the correct format specifiers.
Here's something to start you off:
Formula:
IF(
AND(
Date, Year
),
DATETIME_PARSE(
Date & " " & Year,
"MMM D YYYY"
)
)That worked! Thank you so much. Currently, it has the time at the end which is unnecessary, how can I remove this with the script you have given me above?
That worked! Thank you so much. Currently, it has the time at the end which is unnecessary, how can I remove this with the script you have given me above?
Ah to do that you'd just need to modify the settings of the field itself and toggle "Include time" off
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.