Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    12

    Unanswered: Comparing to NULL

    im trying to write a selection formula that will select the records where recordtype =1 and date is null
    if a date is entered it shows that it is completed, but if there is no date it has not been completed.
    This is what i have.

    {Comments.RecordType} = 1 and {Comments.CompletionDate} = NULL

    How do i ask it to check if it is null?

  2. #2
    Join Date
    Mar 2006
    Posts
    12
    to do this use the function IsNull

    IsNull({Comments.CompletionDate}) and
    {Comments.RecordType} = 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •