SteveP
Member
In the DREAM Writer, you can use a date selection like somedate LT *TODAY +21 to get records where somedate is in the next 21 days. However, for World Writer, I get an SQL0104 error.
I want to select records based on the current system date. From the Price file F4106 if that matters. I want to select as follows
Expired Date GT current-date
Effective Date LT current-date.
I must be using the wrong search terms as I am sure this is a common problem.
Camn anyone tell me the syuntax for searching a date field with a comparison to the current date?
I want to select records based on the current system date. From the Price file F4106 if that matters. I want to select as follows
Expired Date GT current-date
Effective Date LT current-date.
I must be using the wrong search terms as I am sure this is a common problem.
Camn anyone tell me the syuntax for searching a date field with a comparison to the current date?