4 Replies Latest reply: Oct 22, 2014 8:37 AM by Anand Chouhan RSS

    Date field that includes day and time stamp

      Dear QV users,


      I have problems with extracting a date stamp in a field that has a date and time stamp. The field is called RealizedIBReady. I included a table as an attachment.


      I tried the MakeDate function:

      MakeDate(Mid(left(RealizedIBReady,4),7,4),Mid(left(RealizedIBReady,4),4,2),Mid(left(RealizedIBReady,4),1,2)) as RealizedIBReadyDay


      Data is extracted from a QVD file. I have imported the field with a left join into the exciting file.