topic Re: timestamp removal form date in QlikView

timestamp removal form date

Mon, 13 Oct 2014 05:23:19 GMT

Hi All,

How do i convert it to DD/MM/YYYY date format??

I tried date(floor(timestamp#(CREATEDDATE,'M/DD/YYYY h:mm:ss[.fff] TT')),'DD/MM/YYYY') as date

But its giving null value .

kindly help

Re: timestamp removal form date

senpradip007 — Mon, 13 Oct 2014 05:25:05 GMT

Try like

SubField(CREATEDDATE, ' ' ) As date

Re: timestamp removal form date

Mon, 13 Oct 2014 05:26:43 GMT

Hi,

Please try with Date(Createdate,'DD/MM/YYYY')

Regards,

Joshmi

Re: timestamp removal form date

senpradip007 — Mon, 13 Oct 2014 05:27:09 GMT

You also try this:

Date(CREATEDDATE, 'DD/MM/YYYY') As date

Re: timestamp removal form date

Mon, 13 Oct 2014 05:27:28 GMT

not working

Re: timestamp removal form date

PrashantSangle — Mon, 13 Oct 2014 05:29:38 GMT

Hi,

Try this

SubField(CREATEDDATE, ' ' ) as NewDate

date(floor(timestamp#(CREATEDDATE,'MM/DD/YYYY hh:mm:ss TT')),'DD/MM/YYYY') as NewDate

Date(Floor(CreteDate),'DD/MM/YYYY')

Regards

Re: timestamp removal form date

ashfaq_haseeb — Mon, 13 Oct 2014 05:30:02 GMT

Hi,

If it is proper date then just try below

Date(floor(CREATEDDATE),'DD/MM/YYYY') as Date

Regards

ASHFAQ

Re: timestamp removal form date

aveeeeeee7en — Mon, 13 Oct 2014 05:30:23 GMT

Try this:

Date(Subfield(Num(CREATEDDATE),'.',1),'DD/MM/YY') AS New_Created_Date

Regards

Av7eN

Re: timestamp removal form date

senpradip007 — Mon, 13 Oct 2014 06:12:51 GMT

I don't know why this is not working, its working fine in my application. Can you please upload sample application?

Re: timestamp removal form date

Thu, 06 Oct 2016 10:16:31 GMT

Try, left(date(CREATEDDATE,'DD/MM/YYYY'),10)

Thanks,