473,396 Members | 2,052 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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];
  7.  
May 3 '12 #1
1 1524
Rabbit
12,516 Expert Mod 8TB
It looks like you're already doing so with the DateAdd function so I'm not sure what you mean.
May 3 '12 #2

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

Similar topics

4
by: Treetop | last post by:
I have a script for my church that we use for the weekly events. I currently have it as week of Feb 1, 2003 at the top, then list Sun - Sat below the date. I have been asked to put the date next...
1
by: Johnny | last post by:
I have a database with a Master table and a Budget table. The Master table has all the data including these 4 fields (Enccredit, Encdebit, Credit and Debit) and related to the Budget table. The...
5
by: Paul D. Fox | last post by:
OK, its a lame question... I think my mind is getting fried today. The Month(Now) function returns a "1" if its Janurary and I'd like it to be a "01". Can anyone help me with this one? P
1
by: Frank Bishop | last post by:
I have been spoiled by some report writing tools that have intrinsic functions like Last Year Month-to-date. I'm looking for a way to emulate this in SQL Server now with my fields that are...
6
by: CsharpGuy | last post by:
I have a date such as 1/1/2005, how can i get the month end date for that month?
2
by: ncsthbell | last post by:
I am having problems getting the end date to calculate correctly. I start with Quarter '03/02', (YY/QTR), for this it means it is for the 2nd qtr of 2003. My goal is to get the begin & end dates...
2
by: dvora123 | last post by:
On my form, I need to be able to have Access autocalculate a 3-month followup: This is what I have so far: My field "Web Reviewed Date" and an unbound text box for 3-month follow-up (next...
1
by: naveenkongati | last post by:
Hi, How do we fetch only date and month from date column (Ex: 2008-11-10) in Mysql? Thanks
1
by: user1980 | last post by:
Hello there Can somebody help me with this. I have a form where the user enters his date of birth from 2 drop downs and a textbox. Month and date are dropdowns and year is to be entered in a text...
0
by: Alex Fung | last post by:
When I use GotFree Cards (http://www.got-free-ecards.com) to send free e-cards, I come across a problem when selecting the future date for sending the card. The webpage uses JavaScript and the...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.