Convert Date Formate

[#1]

Hi Friends,

I need to convert the date format as below, Can someone please help me on this???

Date format at Source: "Sep 29,2015  12:04:58 PM"

I need to convert the date into "29-09-2015" (i.e. in DD-MM-YYYY format without time).

Thank you in Advance.

Best Regards,

Bhavesh Jain

[sasiparupudi1 · Accepted solution]

=Date(floor(Timestamp#('Sep 29,2015  12:04:58 PM','MMM DD,YYYY  hh:mm:ss TT')),'DD/MM/YYYY')

[Anonymous]

Hi Bhavesh,

date#(Date(Date field,'DD-MM-YYYY'))

[sasiparupudi1]

=Date(floor(Timestamp#('Sep 29,2015  12:04:58 PM','MMM DD,YYYY  hh:mm:ss TT')),'DD-MM-YYYY')

[avinashelite]

try like this:

date(floor(Date_field),'DD-MM-YYYY')

[#6]

Thank you !! It worked

[sasiparupudi1]

You are welcome