10 Replies Latest reply: May 30, 2015 8:55 PM by Yeo Poh sai RSS

    How to create a date from month and year ?

    Yeo Poh sai

      Hi All



      Now i am using below script for date field :-



      makedate(@53:57T,@50:52T,1) as date,



      Which is wrong , so i change the above field name to date_ ( insted of date )



      makedate(@53:57T,@50:52T,1) as date_,



      Now i need change to using below 2 field to form the above date field :-



      @50:52T  as month_,


      @53:57T  as year_,



      Now my question is , what is the expression should be , so that above 2 field will be able to create field name same sa date field above ?



      For the day i can fill with 1.