Date Condition

[upaliwije]

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'

[gautik92]

Wat abt this?

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and Month(LOSS_DATE)>='Oct' and Year(LOSS_DATE)>='2012'

[MK_QSL]

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and LOSS_DATE>='01/10/2012'

[jonathandienst · Accepted solution]

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');

[ashfaq_haseeb]

Hi,

Try like Below

Load * from ................

(qvd)

WHERE MATCH (CLA_CODE,'MC','M4')

and where MonthName (LOSS_DATE)= 'Oct 2012';