Newer Version Available
date_to_string(DateTime | DateOnly, formatString)
Converts a date to a string.
This function takes a DateTime, DateOnly, or now() as its first argument. For the allowed formats, see the Analytics External Data Format Reference.
Use date_to_string() to display the close date for your opportunities in the format yyyy-mm-dd.
1q = foreach q generate date_to_string('CloseDate', "yyyy-MM-dd") as "Close Date";