How can I convert an Excel date code into a normal M/D/Y formatted date?

HowDoIDomo

Hi All,

I have some data that I link to DOMO via the Google Analytics connector. It's provided by a 3rd party and contains dates in Excel codes in their 4** format.

Is there a recommended Beast Mode or other way to fix the date formatting? Due to IT policy, I can't access google sheets to change it manually. Plus, I would have to do that every time the consultant makes an update.

So, I was wondering if anyone knows of a Best Mode formula or Magic ETL tile that could automate that process for me until I can meet with the consultant about the formatting.

Thanks in Advance!

DashboardDude

Hi @HowDoIDomo ,

So the start of that 4** date is Jan 1, 1900 so you need to create a column in an ETL with that Date and then add your number of days to that date. I made a video for you to see:

https://www.loom.com/share/aa615abfec9645218b42ba8a78ad80be

John Le

You're only one dashboard away. 

More video solutions at: https://www.dashboarddudes.com/pantry

HowDoIDomo

Hi John @DashboardDude ,

Thank you so much! That did the trick. Plus your tutorial was very easy to follow.

I've already bookmarked your web page for the next time I need help.

Thanks,

Carlos AKA HowDoIDomo?

DashboardDude

@HowDoIDomo ,

Happy to help!