How to convert a class function integer date format to date format
I am using the following:
Class(if(Not IsNull(date(PDate)) and
Date(PDate) >= Today()-91 and date(PDate) < today(), date(PDate)),7,'to')
The date comes out as an integer, I need it to be in MM-DD-YYYY format. I wasn't able to find anything in the forum or help. I've already used the date(PO_Create_Date) function, but it still is returning only the date integer.