Calculating Difference in days

  • Thread starter Thread starter cmraguilar
  • Start date Start date
C

cmraguilar

I need to find the difference of the current date and an input value. It
will be run in a query as a calculation and then used in a graph. Basically
i'm trying to made a Gantt chart that will display 2 weeks back and 2 weeks
ahead.

The input value is [ExpectedDate].

Thanks
 
Check Access HELP for the syntax on using the DateDiff() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff. Thanks exactly what I was looking for.

Jeff Boyce said:
Check Access HELP for the syntax on using the DateDiff() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP

cmraguilar said:
I need to find the difference of the current date and an input value. It
will be run in a query as a calculation and then used in a graph.
Basically
i'm trying to made a Gantt chart that will display 2 weeks back and 2
weeks
ahead.

The input value is [ExpectedDate].

Thanks
Click to expand...
Click to expand...
 
Back
Top