date calculate

  • Thread starter Thread starter Ezekiël
  • Start date Start date
E

Ezekiël

Hi

How can i calculate e.g. 01-01-2004 minus 7 months or plus 2 months?

Greetings,

Ezekiël
 
Hi,



DateAdd("m", -7, #01-01-2004#)

DateAdd("m", 2, #01-01-2004#)


Hoping it may help,
Vadnerghast, Access MVP
 
Thnx Michel!


Michel Walsh said:
Hi,



DateAdd("m", -7, #01-01-2004#)

DateAdd("m", 2, #01-01-2004#)


Hoping it may help,
Vadnerghast, Access MVP
Click to expand...
 
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

Access Count dates within a Month 4
calculate Age problem date notation european american format 2
Creating a "grid" of data 3
Changing date fotmats & calculating date - HELP 5
Looking up across date ranges in Access 2
Access Running Balance in Access 1
calculate two dates 1
Count(*) with different period 5

Back
Top