Solved

VB Date

Posted on 2011-09-29
2
355 Views
Last Modified: 2012-08-13
I have some code behind a button in Access.  One of the tasks it completes is to add the current date in one of the fields.  It isn't working.  It adds random dates.  Instead of 9/29/11 for today's date, It returns 9/10/11.  I have confirmed that my system time is correct.  What is wrong with this statement?

rs!PullDate = Date

I tried to write it as rs!PullDate = Date(), but VB removes the ().

Thanks,
Tammy
0
Comment
Question by:tammyborden32
2 Comments
 
LVL 25

Accepted Solution

by:
Luis Pérez earned 500 total points
ID: 36814980
Try Now instead Date.

rs!PullDate = Now

Hope that helps.
0
 

Author Closing Comment

by:tammyborden32
ID: 36815317
That did.  Once again Experts-Exchange to the rescue!!!!
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question