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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
sraikwar
Contributor
Contributor

Code to change Date Automatically

=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 .

3 Replies
eduardo_dimperio
Specialist II
Specialist II

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

Anil_Babu_Samineni

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')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sraikwar
Contributor
Contributor
Author

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