Create date field from

Question & Answer
,
1

Hello,

I have 3 fields, day,month,year. eg. value are 01,12,2024 respectively. I wanted to create a date field from these 3 fields

Tried this but the result is null it says invalid date.
parseDate(concat(toString(month), “/” ,toString(day), “/” ,toString(year)))

image
image237×151 7.91 KB

reference > Creating Date Field

I would appreciate your help guys.

2

Hi @EJRD

Your approach is close, but it has syntax issues in the parseDate function. Try this corrected formula.

Example:

parseDate(concat(toString(month), '/', toString(day), '/', toString(year)), 'MM/dd/yyyy')

Hope this helps!

1 Like
3

Thank you that works, I did not realize that format statement.