Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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"