using current year in querystring 1

[kiwieur]

Hi,

I have this query string at the moment

<a class="nav" href="OTIF_YearCharts.asp?aYear=2015" target="cpOTIF_Main" >Charta OTIF 2015</a>

I would like to change it so that it would use the current year so that I do not have to change it at the start of each year. I have tried

<a class="nav" href="OTIF_YearCharts.asp?aYear=Year()" target="cpOTIF_Main" >Charta OTIF 2014</a>

But that does not work

Does anyone have any ideas please


Regards

Paul

 

[gmmastros]

try:

Year(Date)

<a class="nav" href="OTIF_YearCharts.asp?aYear=Year(Date)" target="cpOTIF_Main" >Charta OTIF 2014</a>

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[kiwieur]

gmmastros thanks for the speedy reply, tried your code but get this error

ADODB.Command error '800a0d5d' 

Application uses a value of the wrong type for the current operation. 

/ChartaPad/OTIF/OTIF_YearCharts.asp, line 20

Regards

Paul

 

[gmmastros]

try this.

<a class="nav" href="OTIF_YearCharts.asp?aYear=" & Year(Date) & " target="cpOTIF_Main" >Charta OTIF 2014</a>

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gk53]

you should use

<a class="nav" href="OTIF_YearCharts.asp?aYear=<% =Year(Date)%>" target="cpOTIF_Main" >Charta OTIF 2014</a>

 

[kiwieur]

gk53,
Thanks for the info, it worked a treat. A star for you

gmmastros, thanks for your input also

Regards

Paul