Solved

VB Date

Posted on 2011-09-29
2
353 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
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 fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now