I have two date fields Current date and Hire date. I also have a difference field.
The Current date is calculated and is displayed as 3/16/2011.
However, the hire date is displayed as 03/01/2011. Nothing is displayed in the difference field. However, if I remove the leading zero from the Hire date field, I get the correct difference.
How do I control the leading zero in one or the other date field?
Thanks,
MDawn