timestamp removal form date

[#1]

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

[senpradip007]

Try like

SubField(CREATEDDATE, ' ' )  As date

[#3]

Hi,

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

Regards,

Joshmi

[senpradip007]

You also try this:

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

[#5]

not working

[PrashantSangle]

Hi,

Try this

SubField(CREATEDDATE, ' ' ) as NewDate

or

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

or

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

Regards

[ashfaq_haseeb]

Hi,

If it is proper date then just try below

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

Regards

ASHFAQ

[aveeeeeee7en]

Try this:

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

Regards

Av7eN

[senpradip007]

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

[#10]

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

Thanks,