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
RS_10_MEMBER_MSTR_110!PRC_END_DATE = "1900-01-01"
How should this be done?
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.