rla
Posts: 18
|
Posted: 05/01/2014, 11:40 AM |
|
Hi,
Anyone have tips for setting up a grid search with search options to find a Date value
- Not Null
- Null
The field is ShipDate, so I want to have a search to show all the items that have shipped and have not shipped based on the date.
I put a drop box in and specify a date > 1/1/1950 showing the all the items with dates in them, but not sure how to specify an option/Selection for Dates with NULL values.
Thanks
Rick
|
|
|
MichaelMcDonald
Posts: 640
|
Posted: 05/01/2014, 4:36 PM |
|
Don't know how it will go using a date prior to the unix epoch,
but you should be able to do some thing like this in your query builder for the grid with the correct result...
where date >= 1
_________________
Central Coast, NSW, Australia.
|
|
|
ckroon
Posts: 869
|
Posted: 05/03/2014, 12:50 AM |
|
Set the Value of a No Date Selection in your Search Listbox.. give it a value of 1.
Then in the Before Build Select Event of the grid, you can change the Where sql to find dates that are Null if that URL value = 1
_________________
Walter Kempees...you are dearly missed. |
|
|
|