Dates.... (1 Viewer)

[fixious]

I am trying to calculate a jail term used for prison guards. For instance I want to enter a date sentence was passed and the amount of time sentenced like 75 days from the date entered. I would also like to be able to add and subtract days for a few other fields if they apply. Thanks for your help, any ideas would be great.

 

[Jack Cowley]

Search help for the DateAdd() function as you will find your answer there.

hth,
Jack

 

[Pat Hartman]

Day is the default increment so if you subtract two dates, you'll get the difference in days. If you add or subtract a whole number from a date, you'll get a date that many days in the future or past. If you want some different increment, you'll need to use the DateDiff() function. If your dates are not stored in fields defined as date/time data type, you'll need to work out the calculations yourself.

 

[fixious]

Thank you, I'll give er a shot...