Hi, :) :) good morning!!
I have a listing of dates and they are all blank. In On-Demand, I'm trying to exclude these days or even in the Query using <> ' ' or NOT NULL. But
it is not taking these days off. I can't remember the command that I used to use "COLAPSE?? Something like that" that replaced 0 for blanks space.
Please help if you have a recommendation.
Thanks a lot
Quote from: HelloCognos on 26 Jul 2018 08:58:31 AM
Hi, :) :) good morning!!
I have a listing of dates and they are all blank. In On-Demand, I'm trying to exclude these days or even in the Query using <> ' ' or NOT NULL. But
it is not taking these days off. I can't remember the command that I used to use "COLAPSE?? Something like that" that replaced 0 for blanks space.
Please help if you have a recommendation.
Thanks a lot
Try using not equal to an empty string. Your example shows a blank space between two single quotes which is not the same thing as an empty string.
[your query item] <> ''
Ah.. OK, I'll try that. No space. Thanks so much!