Create a date field from separate month and year fields

deona720

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?

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

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