Somebody might have touched on this topic already but i failed to find it in my search so decided to post my question.
I am validating to check the innertext of en element; so my XPath is as follows:
".............\div/div/div/h2[@innertext~'(?i:06 December 2011)']"
Now, obviously the date will change and I want to pass that through as a variable, whereby it gets picked from an Excel spreadsheet using the formula "=TEXT(TODAY(),"dd mmmm yyyy")".
I am using the regular expression of ~'(?i:06 December 2011)'] because Excel displays the date as "06 December 2011" and the innertext value equals "06 december 2011". Hence, me using this expression matches the text regardless of case sensitivity.
Now my problem is this, how can i keep this regular expression but pass the value through as a variable. If i do the below, Ranorex does not identify it as a variable.

".............\div/div/div/h2[@innertext~'(?i:$Var_CurrentDate)']"
Clearly i am not doing it correctly, more to the point, can we?
I do not want to use code as we are trying to refrain from any code. Reason being, we want our solution accessible to all Testers (who lack C# experience) so that they can modify the scripts if required.
Regards
Nadeem