need expression using yearfrac

  • Thread starter Thread starter Mary Lou
  • Start date Start date
M

Mary Lou

I am trying to use 2 date and calculate days between.

This is a example

12/1/03 - 12/15/03 = 14
 
HI,
Have you looked at the DateDiff function?
?DateDiff("d","12/1/03","12/15/03")
14
 
DateDiff works swell and gives us the answer needed, thank
you.
Mary Lou
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converted from LINUX time ok, but having issues with the between date. 4
Advanced problem using auto-number and datediff to find readmissio 1
Transpose rows to columns in Access. 3
Odd results from Crosstab w/ Date/Time field 1
Access Running Balance in Access 1
Eliminate repeat values in one field 7
Excel Catagorise AM or PM 7
yearfrac format error? 4

Back
Top