3 Replies Latest reply on Nov 4, 2011 2:36 AM by guest contributor

    Calculate DATE field from integer month, day, year

    Jerry Wetherall

      I'm sure there is a simple answer to this, but I'm stumped. I've got integer fields of month, day and year (for example: 7, 23, 2010).  I want to use these to calculate a DATE field.  Then I want to calculate the difference between a pair of the DATE variables, in days.  Every approach I've tried gives me null dates. Could anyone show me how to achieve what I want?  Thanks.