6 Replies Latest reply: Sep 14, 2015 12:13 PM by Ernesto Vizcaya RSS

    Convert Date in Date number like Excel Date number

    Ernesto Vizcaya

      hi,

       

      I´m new in QS and I need to convert Date to a Number Date, for example

       

       

      01-09-2015          42.248
      02-09-2015          42.249
      03-09-2015          42.250

       

      a) I have a File name : 01-09-2015 NOM.xlxs

       

      b) I have Date in Text Format : Replace ( Left( FileName(), 10 ) , '-' , '/' )

       

      know, I need to convert this Date in Number (like Excel number)

       

      regards.