Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mshailaja
Contributor III
Contributor III

need help

hi

i have date format like this

i need like this

7 Replies
Anil_Babu_Samineni

May be this

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

Or

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

or if you have real dual dates yet  then

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

Kushal_Chawda

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

SET DateFormat='DD-MMM-YYYY';

mshailaja
Contributor III
Contributor III
Author

Anyoneplease help

dathathreya
Creator
Creator

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

colin_albert

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

Get the Dates Right

Why don’t my dates work?

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)