5 Replies Latest reply: Nov 8, 2016 10:01 PM by Michele Van Laningham RSS

    How to convert a class function integer date format to date format

    Michele Van Laningham



      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.


      Any ideas, please?