Date Calculate

[gary_getter1]

I want to calculate a data from anthony table, like (20 Jan 2005) + 365 days
will be 20 Jan 2006, how can i do it.

The Table setting is just like below:
Constituent (DataID,...);
Student (DataID, DOB,...);
School (DataID, 4YearsOld(As a Date Format),...)

Anyone can help me, Thank you.

 

[Rich]

Look up the DateAdd function

 

[allan57]

Look at DateAdd function in help

 

[gary_getter1]

Thank you!!