Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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

3 Replies
tresesco
MVP
MVP

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

tresesco
MVP
MVP

May be like this?

Set WSHShell = CreateObject("Wscript.Shell")

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