CDate Invalid Use of Null Error

**fourboyz** · 01-18-2023, 09:44 AM

Getting 'Invalid use of Null' on a cdate expression. How do I fix this?

**Welshgasman** · 01-18-2023, 10:25 AM

Use the NZ() funcrion and a default date?
Or check it is a date with IsDate()

**fourboyz** · 01-18-2023, 11:58 AM

Originally Posted by Welshgasman

Use the NZ() funcrion and a default date?
Or check it is a date with IsDate()

Thank you! Is working now!

**Welshgasman** · 01-18-2023, 12:22 PM

Originally Posted by fourboyz

Thank you! Is working now!

Well please show the end result. It could help others in the future.

**fourboyz** · 01-18-2023, 12:46 PM

Originally Posted by Welshgasman

Well please show the end result. It could help others in the future.

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

CDate Invalid Use of Null Error

Thread Tools

CDate Invalid Use of Null Error

Similar Threads

Run time error '94' Invalid use of Null

Run-time error 94: Invalid use of null/ Code has been working for over a month, now I get this error

Invalid use of NULL error

CDate and CStr issue with "Invalid Use of Null" Issue

Error 94: Invalid Use of Null

Tags for this Thread

Posting Permissions