Checking for a null DateTime value (1 reply and 1 comment)
What does CDate return you?
One alternative might be to create a SQL view that does the filtering for you. It will be faster than having IMan manipulate the data itself saving you some processing time.
Hi Django, thanks for that. Yes I often contemplate whether to perform operations in (beloved) SQL or see if IMan can handle it. I ultimately got this working by using the formula :
%MS_DateNotified 0
which wrecked my head. But I think IMan sometimes interprets NULL values as 0 and I just hadn't tried this permutation.
Hello,
I'm looking for advice on using a Filter formula. The goal is to filter out any records where the "Date Notified" value in a date/time field is NULL.
In the SQL Server database, the value is null for multiple rows.
IMAN is not interpreting them as NULL, I think. Any advice on the correct formula to use?
I have attempted to use these variations:
IsNull(%MS_DateNotified) = 1
%MS_DateNotified = ""
Trim(%MS_DateNotified) = " "
Trim(%MS_DateNotified) = ""
InStr(%MS_DateNotified, ":") = 0
I'm thinking the problem is that I'm trying to use String functions on a Date/Time field. But I'm unsure what a better route would be. Other suggestions would be helpful. Thanks!
Arline