Load Fields where a Field is empty (has no value)

[sammo]

Hello Community

I have a question about loading a qvd-File like this:

Load
  ID,
  Name, 
  Surname, 
  Birthdate, 
  Address, 
  City
FROM Adresses.qvd
WHERE Birthdate > then date('01.01.1950', 'dd.mm.yyyy') OR Birthdate = '';

So i want to load all de rows where the birthdate is higher than 1950 and all the rows which have an empty birthdate-field. 

the bigger than works fine, but the rows with the empty birthdates are not in the resulting dataset.

any ideas? 

thank you very much!

[Anil_Babu_Samineni · Accepted solution]

If your date format is the valid, U can try

Load
  ID,
  Name, 
  Surname, 
  Birthdate, 
  Address, 
  City
FROM Adresses.qvd
WHERE Year(Birthdate) > 1950 or IsNull(Birthdate);