troubleshooting Question

MS Access Convert 'CCYY-MM-DD' To DateTime Type

Avatar of Bob Collison
Bob CollisonFlag for Canada asked on
Microsoft Access
7 Comments1 Solution399 ViewsLast Modified:
I have a DateTime field in a MS Access Application / Table that I need to load with the String  "CCYY-MM-DD" in an Event Procedure when the extracted data for loading doesn't have a value.

PRC_END_DATE is Data Type DateTime in both tables.

Here is the code that produces a Type Mismatch error.

If Not IsNull(RS_10_MEMBER_MSTR_120!PRC_END_DATE) And RS_10_MEMBER_MSTR_120!PRC_END_DATE <> "" Then
   RS_10_MEMBER_MSTR_110!PRC_END_DATE = RS_10_MEMBER_MSTR_120!PRC_END_DATE
Else
   RS_10_MEMBER_MSTR_110!PRC_END_DATE = "1900-01-01"
End If

How should this be done?
Thanks.
Bob C.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros