Query for Null Dates

Kathy Andersen

26. Juni 2015 01:52

Does anyone know if it's possible to use the Query Builder to search a date field for nulls?

0

• 

  Permanently deleted user

  26. Juni 2015 02:08

  Yes, I just tried it.  You put in the date field, then use the "Is Null" operator.  When you use a data field, the system automatically puts in a date value in the right hand box, which you need to erase to get it to work.

  You can also do this in the Filter by adding the date field, then selecting the "Is" operator and then you have to type in NULL in the bottom SQL box.

  0
• 

  Permanently deleted user

  26. Juni 2015 02:10

  sorry, should've said "when you use a date field" instead of "data field"

  0
• 

  Kathy Andersen

  30. Juni 2015 20:05

  Thank you Mike, but I don't see "Is Null" as a choice for operator for date fields in the query tool.  I also do not see the SQL box in the filter tool.  Are you using the SL viewer?

  We are on GE 4.3 / GVH5 2.4

  /customer/servlet/servlet.FileDownload?file=00P6000000elzNBEAY

  0
• 

  Permanently deleted user

  1. Juli 2015 02:29

  Sorry, I was looking at Silverlight.  I agree, NULL is not an option for dates in HTML5

  0
• 

  Kathy Andersen

  1. Juli 2015 02:36

  It's all very new to us, so thank you for the clarification Mike.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.