5 Replies Latest reply on Nov 8, 2015 2:09 PM by Prayson Wilfred Daniel

    Calculate DATE field from integer month, day, year

    Ratan Samudrala

      I've got individual integer fields of month, day and year. 

      I want to use these fields collectively to calculate a DATE field.


      I tried to use below formula for creating a DATE field:


      But resulting with null's.


      I checked for STR([month]) results months and similarly for the others as well.. But when used collectively in the above formula not getting desired results.


      Thanks in advance..