Time elipsed since a job order has been entered

[klr397]

I need to create two diffrent reports

one that states how many days since a job order was entered

date entered

and on that satates how long it has been since a resume has been sent to a job order

date sent

does anone have any idea how i would accomplish this i was trying to do date entered + now() but even i knew that wouldnt work.

 

[SammyJ]

Actually, you're close. Dates are just numbers, being the number of days since the end of 1899 or something. So Now() - [Date Entered] will give you roughly the right answer. Just be careful of times and rounding, as you might get an extra day if it is after 12 midday. Use the Fix function to sort it out.

 

[SammyJ]

I should probably add that there is a DateDiff function which you can use if you're more comfortable with that. Look it up in the help.

 

[klr397]

fabulous! thanks a bunch