Hi
Could you please update me where the error in Syntax.
I had a User entry Variable on Cal Year/Week in my query.
My requirment is to display a drop down list of Week No (1-52).
For this reason i created a Drop Down with Static List of 1-52 weeks.
So User selects week no between 1-52 from the drop down and
So based on user selected week the variable should be populated user selected week and current year.
Ex: If user selects 39 from Dropdown then the variable Cal Year/Week should be populated as 200939
For that purpose i am writing the below formula but its not working could you please update me what is wrong
'MID(NOW(),7,4)+@Week'
(Basically the formula is getting Current Year from Current date (now) and concentating it with user entered week)
Please update me
Thanks