Date format

[#1]

Hi

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

[tresB]

May be like this?

set up = ActiveDocument.GetApplication.GetUserPreferences

up.UseSystemDateTime = true

up.DateTimeFormat = "MM/DD/YYYY"

ActiveDocument.GetApplication.SetUserPreferences up

[#3]

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

[#4]

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