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:

      DATE(STR([month])+"/"+STR([day])+"/"+STR([year]))

      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..