changing format

[#1]

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

[maleksafa]

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';

[Anonymous]

Hi

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

[er_mohit]

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

[Anonymous]

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]

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....

[#8]

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