How to put ‘ALL’ in DATE object LOV list? Please share your idea. For the Number and Char object, it is no problem but I have problem in DATE object.
Philip (BOB member since 2006-03-02)
Hi,
Did you Search in the forum first, please read the FAQ’s on this forum related to your product, this topic has been discussed many times… Please Click the links to find more info.
You may have to convert your Date type … 
https://bobj-board.org/t/60982
Hope that helps.
BO_Chief 
(BOB member since 2004-06-06)
We had discussed on Character type only. But I need ALL in DATE object.
Philip (BOB member since 2006-03-02)
If you are adamant about using the word ‘ALL’ in a field of data type DATE I am afraid you are fighting an already lost battle. Fact is the word ‘ALL’ just is not a date, period.
Andreas 
(BOB member since 2002-06-20)
I will second what Andreas said. Also, conventional thinking is that a LOV for dates is simply not necessary. It’s much faster to just type it in.
However, if you do want some sort of an “ALL” concept, use a dummy date (like 1/1/1900) to represent ALL.
Dwayne Hoffpauir (BOB member since 2002-09-19)
yes i put dummy date 09/09/9999 but it is not working
Philip (BOB member since 2006-03-02)
Can you post your SQL generated here…
BO_Chief (BOB member since 2004-06-06)