date recode

[wakiwi]

I have a problem a bit like pinkpepink. I need a new variable that is yes or no based on whether the date field is blank or not. How would I change the code below to code "yes" if the field were blank and "no" if it is not null? I have tried "Not IsNUll" several ways but it isn't working.

YesNO: IIF([Date1]>=[Date2],"YES","NO")

 

[mresann]

Access can be quirky. Fields which don't contain data may not necessarily be null, although date fields (which are technically Double numbers) should register null. Therefore, if checking for null values, you may have to further query to for zero-length string values (which are NOT null values!).

In your case, however, since you are checking for the Date, you can more readily use the IsDate function. So no matter if the field is Null or zero length, if there is no date format in the field, you will get a no date indication.

Here is my example:

DatePresent: Iif(IsDate([Date1]), "YES", "NO")

NOTE: "Yes" indicates presence of a date, and "NO" indicates absence of a date.

 

[Pat Hartman]

Since IsDate(Date1) tells you whether a date is present or not, DatePresent is redundant and therefore, unnecessary.