Date Issue

Avatar

Avatar

jimb2068

Avatar

jimb2068

jimb2068

05-01-2017

When I enter a date prior to 1930 it shows up as 2000 for example 1929 would be 2029.  How do I fix this?  I have a form where ages are calculated and when a person is born prior to 1930 it will not calculate properly.

Any help is appreciated,

Jim

View Entire Topic

Avatar

Avatar

jimb2068

Avatar

jimb2068

jimb2068

11-01-2017

Hi Radzmar and thank you for the response.

I used a javascript to format the dates and did not use a pattern.  I need to enter the dates MMDDYY and have it format to MM-DD-YY. I found when I used a FormCalc the dates disappeared from the form when it was saved.  

When I enter the current date and then a birth date to calculate the age and the birth date is before 1930 it gives me a negative number.  For example if I enter 01-11-17 and the birth date of 01-26-29 it gives an age of -13.

It is currently in a text field but gives the same result in a date field.

I can send you the form if need be, but I guess I can't attach an attachment through here.

Jim