Creating A Date Field

pauljames · 2024-02-09T19:36:58+00:00

There was an error rendering this rich post.

Hi Domo Community,

How would I go about creating a usable date field from two columns I have? One column is the year, and the other is the month. How could I create a date field from those two columns? For example, 2/1/2024 from a column that has February and a column that has 2024.

Thanks!

Find more posts tagged with

Magic ETL

Beast Mode

Accepted answers

MichelleH

@pauljames You can do this by concatenating the month and year into a date format, then using the STR_TO_DATE function to convert it into a date field.

STR_TO_DATE(CONCAT(`Month`,' 1, ',`Year`),'%M %d, %Y')

All comments

MichelleH

@pauljames You can do this by concatenating the month and year into a date format, then using the STR_TO_DATE function to convert it into a date field.

STR_TO_DATE(CONCAT(`Month`,' 1, ',`Year`),'%M %d, %Y')

MarkSnodgrass

Similarly, you can do:

DATE(CONCAT(`Month`,'/1/',`Year`))

pauljames

@MichelleH thank you!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of