Revisions to Sharepoint 2013 Search Keyword Query Language (KQL) field value is null or empty

added 2 characters in body

Source Link

edited May 6, 2015 at 12:32

Something based off whats here already, but put together fully for how iI needed it and incasein case anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Something based off whats here already but put together fully for how i needed it and incase anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Something based off whats here already, but put together fully for how I needed it and in case anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

improved formatting

Source Link

Something based off whats here already but put together fully for how i needed it and incase anyone else needs this.

Where a start datestart date is blank or before nownow and an end dateend date is blank or after nownow is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Something based off whats here already but put together fully for how i needed it and incase anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Something based off whats here already but put together fully for how i needed it and incase anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Source Link

created May 6, 2015 at 11:54

Something based off whats here already but put together fully for how i needed it and incase anyone else needs this.

Where a start date is blank or before now and an end date is blank or after now is as follows.

-EndDate:1900-01-01..{Today} -StartDate:{Today}..3000-12-31

Return to Answer