I have placed a date of birth search field on my smart filter along with several other search fields. Everything works fine except for a search on DOB before 01/01/1950. Where, or how can I manipulate this to work. If I enter a record with a DOB of 01/01/2049 a search of 01/01/1949 will find this record, that is not what I need to do!
DOB before 01/01/1950
- Thread starter goslows
- Start date
toby.Harman
Member
1. You need to ensure that you set the format of the field to be a 4 digit year (99/99/9999)
2. If you want to change your year offset (the range which Progress will use to default the entry of a 2 digit year) investigate the session:date-offset handle.
Progress dates work well natively since they are stored as an integer offset from 31/12/4713 BC. Once the dates are entered correctly there should be no problem.
2. If you want to change your year offset (the range which Progress will use to default the entry of a 2 digit year) investigate the session:date-offset handle.
Progress dates work well natively since they are stored as an integer offset from 31/12/4713 BC. Once the dates are entered correctly there should be no problem.
vinod_home
Member
The format on both the fields should be with 4 digit year. Not only the search field
HTH
HTH
goslows said:
toby.Harman
Member
Mea Culpa - I didn't check the exact details of the attribute .
I was referring to the session:Year-Offset attribute. My thinking was that you could set this to something sensible (year(today) - 100?) prior to making the DOB entry points available and this would then mean that anyone keying in a 2 digit year would default to within the last 100 years.
I was referring to the session:Year-Offset attribute. My thinking was that you could set this to something sensible (year(today) - 100?) prior to making the DOB entry points available and this would then mean that anyone keying in a 2 digit year would default to within the last 100 years.