Skip to main content

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

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"
)
)

Link to base

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"
)
)

Link to base


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

Reply


Terms & Conditions