Date() function

[petercummins]

Hi Guys,

Does anybody know the formula for validating a date in a DOB field.

I want it to only allow dates where the age is at least 18years old.

Something like '<Date()-18' (But a formula that works!)

Thanks in advance!

 

[namliam]

Dateadd function is what you are looking for

Read the help on how it works....

 

[selenau837]

Hi Guys,

Does anybody know the formula for validating a date in a DOB field.

I want it to only allow dates where the age is at least 18years old.

Something like '<Date()-18' (But a formula that works!)

Thanks in advance!

try something like this.

Dim age as int

age = DateDiff("yyyy",Now(),[DOB Field Name])

Then use the age variable to do your calculations for your validation.

 

[MarkK]

Searched yet? Try "Calculate Age." See if it returns less than a hundred threads.

 

[petercummins]

Thanks people. I have it working now

 

[selenau837]

Thanks people. I have it working now

Can you please post how you did it so others can learn from you in the future.

 

[petercummins]

<DateAdd('yyyy',-18,Date())

This subtracts 18years off the system date. I used this as the Date of Birth on the entry form had to be valid to 18years old or older.

 

[selenau837]

<DateAdd('yyyy',-18,Date())

This subtracts 18years off the system date. I used this as the Date of Birth on the entry form had to be valid to 18years old or older.

Thank you,

I apparently was going about it the hard way. Well, I have a tendacy of doing that.

Good job for figuring it out on your own.