topic Re: need help in QlikView

need help

mshailaja — Wed, 25 Nov 2020 16:16:04 GMT

i have date format like this

i need like this

Anil_Babu_Samineni — Tue, 18 Apr 2017 06:25:59 GMT

May be this

Date(Date#([Open Date],'M/DD/YYYY'),'DD-MMM-YYYY')

Date(Date#([Open Date],'MM/DD/YYYY'),'DD-MMM-YYYY')

Anonymous — Tue, 18 Apr 2017 06:28:33 GMT

or if you have real dual dates yet then

Date([Open Date],'DD-MMM-YYYY')

Kushal_Chawda — Tue, 18 Apr 2017 07:23:21 GMT

if you data is in actual Date format just set the variable like below

SET DateFormat='DD-MMM-YYYY';

mshailaja — Tue, 18 Apr 2017 07:48:22 GMT

Anyoneplease help

dathathreya — Tue, 18 Apr 2017 09:28:57 GMT

now your format is in DD-MM-YYYY so please change it into DD-MMM-YYYY

Colin-Albert — Tue, 18 Apr 2017 09:40:17 GMT

Here are some useful posts on how to format dates correctly.

Anil_Babu_Samineni — Tue, 18 Apr 2017 10:28:08 GMT

What help you wnt, Does all replies is not working for you? Can you describe more