topic Re: Convert Date Formate in QlikView

Convert Date Formate

Fri, 20 Nov 2020 18:02:30 GMT

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 — Tue, 29 Sep 2015 13:01:32 GMT

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

Anonymous — Tue, 29 Sep 2015 13:02:19 GMT

Hi Bhavesh,

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

sasiparupudi1 — Tue, 29 Sep 2015 13:02:27 GMT

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

avinashelite — Tue, 29 Sep 2015 13:04:29 GMT

try like this:

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

Tue, 29 Sep 2015 13:12:27 GMT

Thank you !! It worked

sasiparupudi1 — Tue, 29 Sep 2015 13:13:52 GMT

You are welcome