Need help converting epochdate to MM/dd/yyyy format

Hello,

I have column of with epoch dates, {class_start_date}, that I need to convert to a MM/dd/yyyy format. I’m new to QuickSight and hoping someone can help.

In excel, I was able to convert the epoch dates using formula: =(A2/86400)+DATE(1970,1,1)

However, this didn’t seem to work in QuickSight.

I also tried formula: epochDate({class_start_date})
But this says incorrect argument type of epochDate(String) when it expects epochDate(number)

I also tried formula: parseDate({class_start_date},“yyyy-MM-dd”)
But this just got null values

Any help would be greatly appreciated!

Hi @hoynejay - if your class_start_date is a String (text) field in your dataset right now (which you can change in the data set editor if you want, to change to an Integer) then make your calculation like this:

epochDate(parseInt({class_start_date}))

Or of you change the data type in you data set to an Int, then you only need the epochDate function to convert it.

1 Like

Thank you! I ended up figuring that out last night and had the same solution :slight_smile: