Creating A Date Field

pauljames

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!

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

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!