Date conversion is not working

[Anonymous]

Hi all

i am taking timedate from oracle database

which is in the format as MMM DD YYYY hh:mmTT

for taking count i converted this in qv script like

Date(Floor(Date#(timedate,'MMM DD YYYY hh:mmTT')),'DD/MM/YYYY') as Date

but with this i am getting only few dates

some thing like for 1/15/2016 we have 4 dates in oracle db

but in qlikview it is showing only two

what might be the reason

please help me

regards,

Mahesh

[prasadcm]

Thanks a lot.

Its working perfectly.

[Michiel_QV_Fan]

[prasadcm]

Hi,

I want to include time along with date,

I tried it

date(date#(subfield(RECIEVED_DATE, chr(32), -1)&subfield(RECIEVED_DATE, chr(32), 2)&subfield(RECIEVED_DATE, chr(32), 3)&SubField(RECIEVED_DATE,chr(32),4), 'YYYYMMMDD hh:mm:ss'),

'DD/MM/YYYY hh:mm:ss')

Where am I going wrong?

[Michiel_QV_Fan]

timesatmp(Timestamp#(...))  instead of date.