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!