Discussion Board for collaboration on QlikView Scripting.
how can i set the system date to a date of my choosing?
SET SYSDATE = '09/09/2014'
in order that Today() = 09/09/2014
Do you mean formatting of system date.
If so please check below:
LET vStartDate = date(today(),'DD-MM-YYYY');
If you want to set your start date or make your choosing today date then write a variable like
Let vToday = Date('09/09/2014','DD/MM/YYYY')
something similar to that: but i am not using a variable vToday, but i am using the function today().
I guess that the date that is referred to today() is some kind of sys date that i need to modify.
How do i do that?
- you can set a variable at the date you want (as Anand suggested)
- but can't change the result of today() function because it use the system clock (well if you change your computer date / time you can)
Returns the current date from the system clock. The timer_mode may have the following values:
0 Date at script run1 Date at function call2 Date when the document was opened
No i think that is not possible when use Today() or Now() they returns the system today date and time. But if you need the 09/09/2014 exactly for today date in the date model then use variable and use Addmonth( ) function to get date dynamically.
I guess you want to do this for testing using QV Desktop.
If that is the case then have a look at the RunAsDate utility, Google it and you'll find it.