Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

changing format

Date
01.07.2014
02.07.2014
07-03-2014
07-04-2014
05-07-2014
06-07-2014
07.07.2014
07.08.2014

this is for july month (IN DD.MM.YYYY , MM-DD-YYYY , DD-MM-YYYY , MM.DD.YYYY FORMAT)and i want it to convert into 'DD/MM/YYYY' FORMAT

7 Replies
maleksafa
Specialist
Specialist

if you want to apply it on all the dashboard, you can change the date format from the Main Page in the script.

SET DateFormat='DD/MMM/YYYY';

venkatasreekant
Specialist
Specialist

Hi

Date(Replace([DateFieldName]),'.','/'),'DD/MM/YYYY')

er_mohit
Master II
Master II

Hi

Can't be possible in qlikview in technical sound. Qlikview  reads only one format at time and rest of one treated as string from.

so, in your case there's in single date field having different format used. so, try to use a single format in your database and call it in qlikview . then you can use that date field in any format which you want.

hope you understand

Regards

Mohit

ashfaq_haseeb

Hi,

Look at  alt function.

Regards

ASHFAQ

bill_markham

Use the alt() function as described in this pdf

http://community.qlik.com/servlet/JiveServlet/previewBody/3102-102-4-4191/DateFields-TechBrief-US_v2...

I have pasted this example in from the pdf.

Alt( Timestamp#(MixDate,'M/D/YYYY h:mm tt'),

Date#(MixDate,'M/D/YYYY'),

Date#(MixDate,'D/M/YYYY'),

Date#(MixDate,'YYYYMMDD'),

Date#(MixDate,'DD.MM.YYYY'),

Date#(MixDate'YYYY-MM-DD')

) as MixDate

MK_QSL
MVP
MVP

QlikView can't read two same format at a time...

Consider that you have

01/07/2014 and 07/01/2014....
QlikView consider it as 1st July and 7th January....

Not applicable
Author

i know but now it can't be done on database end