HELP - How to calculate DAYS ELAPSED

[cessna-ak]

I have two date fields and I am needing to calculate how many days have passed between them (ie., end date minus start date = elapsed number of days). Example: 1/15/04 - 1/10/03 = 370

I have searced high and low and am unable to find what I would think is an easy solution. Your help would be greatly appreciated.

[The Shadow]

You just subtract them:

endDate - startDate

If one of them is literal, use GetAsDate():

GetAsDate("1/15/2004") - GetAsDate("1/10/03")

[cessna-ak]

THANK YOU SHADOW!!! I have been messing with this for over a month and just couldnt figure it out and couldnt find info on line about it. In 6, I had a plug in that did all the date calcs for me.

just subtracting them didn't ever work right, but using the GetAsDate function worked right away. THANK YOU!