UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Date Calculation    
 
   
Phamacom
post Jul 26 2005, 04:32 AM
Post #1

UtterAccess Enthusiast
Posts: 62
From: California
Hey All,

I hope this is not a dumb question. Given any date, what calculation should I use to get the first date of the seventh month. So for example, given date 6/4/05 how do I get to 8/1/05 or 9/1/05 or 10/1/05. Thanks for the help in advance.

Phamacom
Go to the top of the page
 
+
freakazeud
post Jul 26 2005, 04:43 AM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
Hi,
try:

DateSerial(Year(YourDate), Month(YourDate)7,1)

HTH
Good luck
Go to the top of the page
 
+
Phamacom
post Jul 26 2005, 04:55 AM
Post #3

UtterAccess Enthusiast
Posts: 62
From: California
Thank you so so so so much. It worked.
Go to the top of the page
 
+
freakazeud
post Jul 26 2005, 04:59 AM
Post #4

UtterAccess VIP
Posts: 31,413
From: NC, USA
You're welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)
Glad I could assist.
Good luck on future projects!
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 02:28 PM