I've recently come across source files that sometimes use valid dates and and excel date codes other times. Here's a formula to dynamically convert to a date using as a field override:

MyDate =if(IsNumeric($_),DateFormat((value($_)-25569)*24*60*60,"M/d/yyyy"),$_)

This converts an excel date code like 43062 to a date string like 11/23/2017.

#TBMStudio

@Jeremy Wilson - Hi - thanks for posting this I've been struggling with one of our data sources that had a mixture of valid dates / codes this has worked perfectly :-)​
Original Message:
Sent: 09-06-2022 10:11
From: Jeremy Wilson
Subject: Convert Excel date code to Date

I've recently come across source files that sometimes use valid dates and and excel date codes other times. Here's a formula to dynamically convert to a date using as a field override:

MyDate =if(IsNumeric($_),DateFormat((value($_)-25569)*24*60*60,"M/d/yyyy"),$_)

This converts an excel date code like 43062 to a date string like 11/23/2017.

#TBMStudio