A function to check if a field value is correct date?

[iliyansomlev]

Hi,

I have a string like 20030934 and another like 19871105 and another like 20030229. Obviously only the second is a correct date. Is there a function in qlikview like IsDate(20030934)  to check if a value is correct date? What is the best way to do this check?

Best,

Iliyan

[eniemenm · Accepted solution]

In the previous answers there seems to be problems with varying amount of days per month. Makedate() can handle those.