Help

Convert date as a text to date file

Topic Labels: Formulas
Solved
Jump to Solution
921 3
cancel
Showing results for 
Search instead for 
Did you mean: 
taylormunroe
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Screenshot 2023-02-21 at 22.36.31.png

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

You'll need to use a formual field with `DATETIME_PARSE()` and the correct format specifiers.

Here's something to start you off:

Screenshot 2023-02-22 at 11.07.59 AM.png

Formula:

IF(
  AND(
    Date, Year
  ),
  DATETIME_PARSE(
    Date & " " & Year,
    "MMM D YYYY"
  )
)

Link to base

See Solution in Thread

3 Replies 3
TheTimeSavingCo
18 - Pluto
18 - Pluto

You'll need to use a formual field with `DATETIME_PARSE()` and the correct format specifiers.

Here's something to start you off:

Screenshot 2023-02-22 at 11.07.59 AM.png

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?

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

Screenshot 2023-02-22 at 8.50.54 PM.png