When I load data from my QVD file the condition highlighted in Red does not give the desired values. Pls advise me to rewrite the condition in a better and correct way
Load * from ................
(qvd)
WHERE MATCH (CLA_CODE,'MC','M4')
and Month(LOSS_DATE) &'-'& YEAR(LOSS_DATE)>='Oct-2012'
A date inequality using strings will not work - you will need to convert these to proper dates so that you have meaningful values to compare. But it looks like LOSS_DATE is already a date value:
WHERE ... And LOSS_DATE >= '2012/10/01'
This will work if LOSS_DATE is a date value and the date in italics is the default date format for you system/model.
If you want to compare to a string, then:
WHERE ... And LOSS_DATE >= Date#('Oct-2012', 'MMM-YYYY');
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
A date inequality using strings will not work - you will need to convert these to proper dates so that you have meaningful values to compare. But it looks like LOSS_DATE is already a date value:
WHERE ... And LOSS_DATE >= '2012/10/01'
This will work if LOSS_DATE is a date value and the date in italics is the default date format for you system/model.
If you want to compare to a string, then:
WHERE ... And LOSS_DATE >= Date#('Oct-2012', 'MMM-YYYY');
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
