Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

Date format in QlikView

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

4 Replies
lironbaram
Partner
Partner

Hi

in your load script use

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

tresesco
MVP
MVP

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

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

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]