Isdate() Function

#1

Hi,

seems simple, but don’t know how to do … :slight_smile:
How can i find out if data is a correct date. Is there a isdate()

Get error, but don’t klnow what data is wrong.
image

in VBA i would do something like this …

if(isdate([field]),[Field],null())

regards,

Adrian

#2

What is a “correct date” in your case?

#3

Hi, good question, VBA seems to recognize everything that can be interpreted as a date - even without a format specification.

image