Conversion or Rewrite

[nicouek]

Hello Everybody

I have a  [DateField] from the source showing the values "20211025" I would like some help transforming it into  (10/25/2021).

Please help...

Thank you

[marcus_sommer · Accepted solution]

You could try: date(date#([DateField], 'YYYYMMDD'), 'MM/DD/YYYY')

- Marcus

[nicouek]

Wow, that was incredible! Thank you again...