Create a date field from separate month and year fields

deona720 · 2024-04-10T13:55:34+00:00

There was an error rendering this rich post.

I have a data set that for some reason has a field for month and a field for year but does not have any date column. Is there a way to string this together in a beastmode to create a date by using the first of every month? Like "01/"&Month&Year?

Find more posts tagged with

Beast Mode

Accepted answers

marcel_luthi

You can use the STR_TO_DATE function to achieve this in conjunction with CONAT. You can find the reference for available functions here: https://domo-support.domo.com/s/article/360043429933?language=en_US

So your formula will look something like:

STR_TO_DATE(CONCAT('01/',`Month`,'/',`Year`),'%d/%m/%Y')

All comments

marcel_luthi

So your formula will look something like:

STR_TO_DATE(CONCAT('01/',`Month`,'/',`Year`),'%d/%m/%Y')