Hi @htlraw
Welcome to the Quick Sight community!
Your calculation looks correct. Please add it at the dataset level. I tested your calculation by creating it in the dataset, and it works fine in the analysis since the calculation is converted to the desired time and stored in SPICE memory.
Different date formats are supported based on the type of dataset used. check the table to see details of supported date formats. refer this parseDate
