10 Replies Latest reply: May 30, 2015 8:55 PM by PAUL YEO RSS

    How to create a date from month and year ?

    PAUL YEO

      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.

       

       

      Paul