String 'YYYYMMDD' to Date Format 'MM/DD/YYYY'

[RThakore]

I have an extracted  string field which has the date value in the 'YYYYMMDD' format. : '20241002'

I need to convert this extracted string to a  Date value with the following  Format:  'MM/DD/YYYY'

What would be the best way to handle this?

[diagonjope · Accepted solution]

Hi @RThakore !

date(date#(YorFieldName, 'YYYYMMDD'), 'MM/DD/YYYY').

Cheers,

+José

[RThakore · Accepted solution]

Thanks diagonjope, this was just what I needed.