QVD Loader

[mohiahmed]

Hello all,

I need your help on a loader.  I am loading data onto a QVD and when I put a date criteria on there it seems to fail. Any pointers would be a great help. 

Many thanks in advance

AGREEMENT:

SQL

SELECT

          ID,

         SOURCESYSTEMID,

         AGREEMENTNUMBER,

         "EFF_STA_DTE",

         "EFF_END_DTE",

         CURRENTLPIRATE

FROM E_AFPG_BASE.AGREEMENT

where EFF_END_DTE >='31/12/3499';

//where Date(Floor(EFF_END_DTE)) >='31/12/3499';

STORE AGREEMENT INTO (QVD);

drop table AGREEMENT;

[mohiahmed]

Thanks Omar, that was perfect.