7 Replies Latest reply: Oct 11, 2017 5:03 PM by Eduardo DImperio RSS

    Convert to Date Format

    Eduardo DImperio

      Hi everyone,

       

      I have this situation, a crosstable from a excel file with a Date Field (in number format) and i tried everything that i know to convert that number to a date format.

       

       

       

      To Data = 43017

      INPUT:

      date(DATA)

      date#( DATA, 'M/D/YY')

      NUM(DATA)

      TEXT(DATA)

      TIMESTAMP(DATA,'DD/MM/YYYY')

       

      OUTPUT:

      null

      43017

      null

      43017

      null