Converting Decimal to String/Date

[dwardTG]

Helo All,

I have a field that has date of birth (ex. 19540417) in it and that field is fixed decimal. I'm am needing to convert the field in designer to a string or date. 

[Thableaus · Accepted solution]

Hi @dwardTG 

Check this link to see how to parse dates.

In your case:

New Field: Date Type

DateTimeParse(ToString([Field]), "%Y%m%d")

Cheers,