Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
hi,
Use the to_Char function like below
to_char(Date, 'DD-MM-YYYY') >= Date(systemdate,'DD-MM-YYYY')