topic Date format in QlikView in QlikView

Date format in QlikView

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date format in QlikView

lironbaram — Fri, 12 Oct 2018 05:08:27 GMT

in your load script use

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

Re: Date format in QlikView

tresB — Fri, 12 Oct 2018 05:09:42 GMT

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#().

Re: Date format in QlikView

andrei_delta — Fri, 12 Oct 2018 08:20:44 GMT

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

Re: Date format in QlikView

arvind1494 — Fri, 12 Oct 2018 09:59:03 GMT

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]