Can I change Month(Now) value only within MsAccess2007

[baba]

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.

SELECT Table1.[StartDate], Count(*) AS Expr1
FROM Table1
WHERE [StartDate] >= dateadd("m" ,-13,DateSerial(Year(Now), Month(Now), 1) )
And (Table1.[EndDate])<DateAdd("m",0,DateSerial(Year(Now()),Month(Now() ),1))
and ( Table1.[System] = "TEST")
GROUP BY Table1.[StartDate];

[June7]

Use a parameter input. The input can be a prompt in the query or reference to control on form.

[Kirsti]

See my post titled "Financial Year not Calendar Year" below. I had a similar issue, & Jim gave very detailed instructions on how to get it working.
https://www.accessforums.net/showthr...-Calendar-Year