2 Replies Latest reply: Apr 11, 2012 8:28 AM by jagan mohan rao appala RSS

    MakeDate as a number

    Martin Goebbels

      Hi, need some help on date / Makedate

       

      If i read a excel file with a "date" column (number formated as a date) into a variable, this variable get's the number representing the date.

       

      If i create a variable with makedate(yyyy,mm,dd) i get dd/mm/yyyy ( my date mask is DateFormat='DD/MM/YYYY' )

       

      how do i do to create this variable as a number, like i had got reading from the excel file?

       

      I believe this question of variables and the use of them in code and set expresssions is very confusing.