Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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');
Wat abt this?
Load * from ................
(qvd)
WHERE MATCH (CLA_CODE,'MC','M4')
and Month(LOSS_DATE)>='Oct' and Year(LOSS_DATE)>='2012'
Load * from ................
(qvd)
WHERE MATCH (CLA_CODE,'MC','M4')
and LOSS_DATE>='01/10/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');
Hi,
Try like Below
Load * from ................
(qvd)
WHERE MATCH (CLA_CODE,'MC','M4')
and where MonthName (LOSS_DATE)= 'Oct 2012';