help with giving condition on datetime field

[Anonymous]

Hi

I have a query which works fine in oracle toad when i give a condition like

Where table1.datetimefield between '01-dec-2010' and '31-dec-2010'

but when i copy and paste same sql in qlikview it does not fetch any data ,

do i need follow any format when giving a between condition in qlikview?

Please Help

Thanks...

[deepakk]

hi,

Use the to_Char function like below

to_char(Date, 'DD-MM-YYYY') >= Date(systemdate,'DD-MM-YYYY')