Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help MACRO

Hi

How can I change Regional Seetings Date format using Qlikview Macro?

thankx

Labels (1)
3 Replies
tresB
Champion III
Champion III

User Preference can be set like:

set up  = ActiveDocument.GetApplication.GetUserPreferences

    up.UseSystemDateTime = true

    up.DateTimeFormat = "YY-MM-DD"

    ActiveDocument.GetApplication.SetUserPreferences up

Not applicable
Author

Sorry for  insufficient information.

I want to change the regional setttings date format of my Machine and not of the Qlikview App

Thanx

tresB
Champion III
Champion III

May be like this?

Set WSHShell = CreateObject("Wscript.Shell")

WSHShell.Run "CMD.EXE /C DATE 12/10/2013"