Convert date as a text to date file

[taylormunroe]

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

[TheTimeSavingCo · Accepted solution]

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

[taylormunroe]

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?

[TheTimeSavingCo]

Ah to do that you'd just need to modify the settings of the field itself and toggle "Include time" off