Use the parseDate function for calculated fields in Amazon Quick Suite.