By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

Can I change Month(Now) date only within MsAccess 2007 DB

P: 16
Can I change Month(Now) in Msaccess to point to someother month without changing the system date in the taskbar date/time settings of my computer.

In otherwords,is there a way to change the date/time settings to affect only MsAccess DB without affecting other documents.

I am using the below query and I want to control Month(Now) to point to a month of my choice rather than taking the system month/date.

Expand|Select|Wrap|Line Numbers
  1. SELECT  Table1.[StartDate],  Count(*) AS Expr1
  2. FROM  Table1
  3. WHERE  [StartDate]  >= dateadd("m" ,-13,DateSerial(Year(Now), Month(Now), 1) )
  4.  And (Table1.[EndDate])<DateAdd("m",0,DateSerial(Year(Now()),Month(Now()),1))
  5. and ( Table1.[System] = "TEST")
  6. GROUP BY  Table1.[StartDate];
May 3 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
It looks like you're already doing so with the DateAdd function so I'm not sure what you mean.
May 3 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.