I am trying to apply  filter aggregate on dateTime Field Column. when i apply the below to different , both of them are not working. any solution ?

MyEntity.ProcessEndDate=#1900-01-01 00:00:00#


or MyEntity.ProcessEndDate=NullDate()


when i print on the screen i am getting "1900-01-01 00:00:00"


Hello Meenakshi,

What do you mean by "not working"? What is the result you are expecting, what is the result you are getting?

If you have a filter in the format FIELD = NullDate() I think you want only the records whose FIELD is NullDate(), right?

But if the data type of the Field is DateTime, you should compare against NullDateTime().

And the problem may not be at this place at all. 

Cheers.

EDIT: I am sleeping. There is no NulLDateTime(). You need to convert it to Date, or compare against #1900-01-01 00:00:00#, that should work. So, the problem may not be that...

Use it:

DateTimeToDate(MyEntity.ProcessEndDate) = NullDate()
Solution

Thanks guys the below option worked for me.

TextToIdentifier(MyEntity.ProcessEndDate) = NullTextIdentifier() or

MyEntity.ProcessEndDate = NullDate()

Solution