topic Date format in QlikView

Date format

Tue, 24 Sep 2013 06:37:15 GMT

I want to change date format in Qlikview macro

How can I do tht?

I can not use ActiveDocument.Evaluate(....)

e.g

Using Date() function I get the Date in dd/mm/yyyy but

I want it in mm/dd/yyyy within Qlikview macro only....

Regards

Avadhoot

Re: Date format

tresB — Tue, 24 Sep 2013 06:50:41 GMT

May be like this?

set up = ActiveDocument.GetApplication.GetUserPreferences

up.UseSystemDateTime = true

up.DateTimeFormat = "MM/DD/YYYY"

ActiveDocument.GetApplication.SetUserPreferences up

Re: Date format

Tue, 24 Sep 2013 07:06:20 GMT

Easier just to change your SET statement in the load script to the format you want, so

SET DateFormat = 'mm/dd/yyyy';

Otherwise in your load you can transform the date as follows

Date(Field,'mm/dd/yyyy') as Date

Re: Date format

Tue, 24 Sep 2013 07:07:47 GMT

No.. I dont Want to change system date format

I just wat to chang format so that user can see it in mm/dd/yyyy as we do it in Qv using Date function

thanks

Avadhoot