topic String 'YYYYMMDD' to Date Format 'MM/DD/YYYY' in App Development

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

RThakore — Wed, 02 Oct 2024 22:05:28 GMT

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 — Wed, 02 Oct 2024 22:20:21 GMT

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

Cheers,

+José

RThakore — Thu, 03 Oct 2024 14:00:50 GMT

Thanks diagonjope, this was just what I needed.