Skip to Content
0
Former Member
Jul 06, 2009 at 09:18 AM

Error in Formula Syntax

74 Views

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