topic Re: Setting/changing dateformat using script in QlikView

Setting/changing dateformat using script

Tue, 23 Sep 2014 07:17:20 GMT

Hi,

I have a question related to dateformat.

First of all, I have to clarify that I don't have a server solution, not does my Qlikview application have internet access.

I get my data from different spreedsheets, some with data from SAP.

My default dateformat is ; 'DD-MM-YYYY' - and I would prefer not to change this.

One of the files that I load to the script contains dates, but in the format 01.03.2013 (1st of march 2013).

How can I use the script so that the date gets showed as 01-03-2013 instead?

Thanks in advance

Martin

avinashelite — Tue, 23 Sep 2014 07:19:17 GMT

Hi,

Try like this:

DATE(filed,'DD-MM-YYYY') as Newfeildname

or you can directly set in the script format

SET DateFormat='DD-MM-YYYY';

amit_saini — Tue, 23 Sep 2014 07:19:48 GMT

Martin,

Try this:

Date(Your_Date_Field , 'DD-MM-YYYY') as Date

Thanks,

maxgro — Tue, 23 Sep 2014 07:21:42 GMT

date(date#(excelfield, 'DD.MM.YYYY'), 'DD-MM-YYYY') as newfielddate

jagan — Tue, 23 Sep 2014 07:22:12 GMT

Hi,

Try like this

LOAD

Date(Date#(DateFieldName, 'DD.MM.YYYY')) AS FormattedDAte

FROM DataSource;

Hope this helps you.

Regards,

jagan.

Colin-Albert — Tue, 23 Sep 2014 07:25:04 GMT

First check that the date format in the SET block at the start of the script has the default date format as 'DD-MM-YYYY'

Then you can use

date(date#(your_date_field, 'DD.MM.YYYY')) as date_field

The date formats must be uppercase.