0 Replies Latest reply: Nov 3, 2016 8:37 AM by JOAO VICENTE FERREIRA RSS

    Date formatting problem

    JOAO VICENTE FERREIRA

      I am trying to format dates (please see my example source file)

       

      In my script I have the following statement:

      Alt(Date#([Creation date], 'M/D/YYYY h:mm'),

      Date#([Creation date], 'D/M/Y hh:mm:ss'),

      Date#([Creation date], 'M/D/YYYY')

      ) as [Creation date]

       

      I tryed to use this without success:

      Alt( Timestamp#([Creation date],'M/D/YYYY h:mm tt'),

        Timestamp#([Creation date],'D/M/YYYY H:mm:ss'),

        Date#([Creation date],'M/D/YYYY'),

        Date#([Creation date],'m/d/YY'),

        Date#([Creation date],'D/M/YYYY'),

        Date#([Creation date],'YYYYMMDD'),

        Date#([Creation date],'DD.MM.YYYY'),

        Date#([Creation date],'YYYY-MM-DD')

        ) as [Creation date], 

       

      In the dashboard I am receiving some dates properly calculated, but the ones that have time stamp for some reason are ignored:

      2016-11-03_10-30-58.jpg

      Where Is my mistake?

       

      Thanks in adavance