Hello:
The following works just fine (and has worked just fine) until today's receipts. The receipts dated today are not found.
select * from t_receipt_master
where rtrim(convert(char,receipt_date,101)) >= rtrim(convert(char,(convert(datetime,'11/01/00')),101))
If I turn the query around and look for :
select * from t_receipt_master
where rtrim(convert(char,receipt_date,101)) <= rtrim(convert(char,(convert(datetime,'01/02/01')),101))
It finds today's receipt date.
Does anyone have any suggestions on why the first part is failing? Any help would be appreciated, the query has been working fine until today.
Thank you in advance..
The following works just fine (and has worked just fine) until today's receipts. The receipts dated today are not found.
select * from t_receipt_master
where rtrim(convert(char,receipt_date,101)) >= rtrim(convert(char,(convert(datetime,'11/01/00')),101))
If I turn the query around and look for :
select * from t_receipt_master
where rtrim(convert(char,receipt_date,101)) <= rtrim(convert(char,(convert(datetime,'01/02/01')),101))
It finds today's receipt date.
Does anyone have any suggestions on why the first part is failing? Any help would be appreciated, the query has been working fine until today.
Thank you in advance..