Sorting Date in MMM-YYYY format in script

[swati_rastogi27]

Hi All ,

Here is the list of Month Year values i have in my QVD:

Dec-2016

Jan-2017

Feb-2017

Mar-2017

Apr-2017

May-2017

Jun-2017

Jul-2017

Aug-2017

Sep-2017

Oct-2017

Nov-2017

Dec-2017

Jan-2018

For Incremental Load , i want to fetch data which is less than Jan-2018 and then concatenate recent data to it

I am using the statement :

Select <>

from <QVD>

where DATE_MONTH < date(MonthStart('Jan-2018'), 'MMM-YYYY')

so using this i don't get anything.

[gerry_hdm]

Hello

Format  the var in 'mm.yyyy'

gruß Gerold

[anagharao]

Try:

Select <>

from <QVD>

where date(DATE_MONTH,'MMM-YYYY') < date(MonthStart('Jan-2018'), 'MMM-YYYY')

Note: if the DATE_MONTH is a predetermined format define that using DATE# function

[tamilarasu · Accepted solution]

Hi Swati,

Select <>

From <QVD>

Where DATE_MONTH < Date(Date#('Jan-2018','MMM-YYYY'),'MMM-YYYY');