7 Replies Latest reply: Jan 9, 2017 2:50 PM by Sunny Talwar RSS

    Unable to calculate Max date

    Aniruddhya Dutta

      Hi All,

      it seems a very simple issue but unable to resolve

       

      I have a 'DATETIME' field in my table whose format is 'MMDDYYYYHHMMSS'

       

      I just want to calculate the max date .

       

      Last_Updated_Date:

      Load

        Max (DATETIME)as MaxDate

        Resident  MasterData;

      let last_Updated_Date= Peek('MaxDate',0,'Last_Updated_Date');


      But MaxDate is returning as below  

      1.PNG




      its treating DATETIME as string i suppose..how to convert it to date?

       

      cheers

      AD