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
image403×409 16.7 KB

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
image385×398 40.6 KB

4

You can use something like the below:

isnumber(date("2022-08-04", "yyyy-MM-dd")) //returns TRUE

But the date format has to be specified beforehand. If you're not sure about the date format, you can test several formats, for instance

isnumber(date("2022-08-04", "yyyy-MM-dd")) OR isnumber(date("2022-08-04", "dd.MM.yyyy"))
5

ok, thanks for reply