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

Welcome Guest ( Log In | Register )

> Change System Date via VBA    
 
   
mac_baum
post Jul 31 2004, 03:40 PM
Post #1

UtterAccess Enthusiast
Posts: 81
From: Canada



Is there any way to change the system date from VBA code? I need to go back one month.However, a general solution would be appreciated ie change day/month/year.

Thanks for your help.
Go to the top of the page
 
+
 
Start new topic
Replies
truittb
post Jul 31 2004, 04:04 PM
Post #2

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)



How about

Date() = #7/31/2004#

or you could use a variable

Date() = dtmYourDate
Go to the top of the page
 
+

Posts in this topic
- mac_baum   Change System Date via VBA   Jul 31 2004, 03:40 PM
- - truittb   Re: Change System Date via VBA   Jul 31 2004, 04:04 PM
- - r_cubed   Re: Change System Date via VBA   Jul 31 2004, 07:15 PM
- - truittb   Re: Change System Date via VBA   Jul 31 2004, 09:34 PM
- - truittb   Re: Change System Date via VBA   Jul 31 2004, 09:42 PM
- - mishej   Re: Change System Date via VBA   Jul 31 2004, 11:14 PM
- - kenick   Re: Change System Date via VBA   Aug 2 2004, 07:12 AM
- - truittb   Re: Change System Date via VBA   Aug 2 2004, 08:34 AM
- - Gustav   Set up a separate machine not connected to corpora...   Feb 7 2012, 04:03 AM


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

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 20th April 2014 - 03:15 AM