topic Re: Code to change Date Automatically in QlikView

Code to change Date Automatically

sraikwar — Wed, 25 Nov 2020 16:16:04 GMT

=date(&num($(month))'/1/'&num($(year)),'MM/DD/YYYY')

Hello,

I need to write a code through which my date after the end of every fiscal changes automatically

i have tried to create two variables of month and year but getting error in that .

eduardo_dimperio — Fri, 11 May 2018 19:54:48 GMT

QS are static, but you can make a task to load every minute

Anil_Babu_Samineni — Sat, 12 May 2018 02:17:43 GMT

For me the expression doesn't make sense? Can you explain what you are trying? This one is correct

=date(num($(=month))&num($(=year)),'MM/DD/YYYY')

sraikwar — Mon, 14 May 2018 11:01:46 GMT

I need to cahnge my date automatically at the begining of every Financial year