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
Solved
Convert date as a text to date file
+3Best answer by TheTimeSavingCo
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"
)
)
+31You'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"
)
)+3You'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?
+31That 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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.