Date format in QlikView

[dhavalvyas]

Hi,

My date format is of MM/DD/YYYY HH:MM:SS

want to convert it into normal DD/MM/YYYY

How to achieve this..can anyone help me out

Thanks in Advanced

[lironbaram]

Hi

in your load script use

date(floor(DateField),'DD/MM/YYYY')

[tresesco]

Rule is:

Date(Date#(YourValue, 'formatASis'), 'DesiredFormat')        

This is assuming your date value is not really date but text. However, if you have a value which is really a date value (numeric values at the backend), you could just use outer date() and leave out date#().

[andrei_delta]

hi,

i think it's best that you change the format from the system variables in the first page and then just simply use date(your_field).

Why? Because you may come across many Date Fields with different formats and when you are using them for expressions you may have problems getting the right expression with it's proper values.

hope it helps,

Andrei

[arvind1494]

first set date format in main script :

SET DateFormat='DD/MM/YYYY';

Use following code in your load script

load Date(Your_Date_Column_Name,'DD/MM/YYY') from your [Path]