Getting 'Invalid use of Null' on a cdate expression. How do I fix this?
Getting 'Invalid use of Null' on a cdate expression. How do I fix this?
Use the NZ() funcrion and a default date?
Or check it is a date with IsDate()
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Large table of over 45K lines - needed data only within my date parameters of 10/1/2022 And 12/30/2022
Found have null values in the date field.
Used following formula in the date Field to fix the issue:
IIf(IsNull([FieldName])=False,CDate([FieldName]),#1/1/1900#) used >=#10/1/2022# And <=#12/30/2022# as the Criteria