This topic is locked

Simple date format question

6/4/2011 9:51:50 AM
ASPRunnerPro General questions
D
dcihon author

I have a access database I am working with. I am on ASPRunnerPro 5.2.

In my access database the date is shown as mm/dd/yyyy

In my ASPRunnerPro page I only want to see the year.

How would I do this without changing the Access Database?

Thanks

Sergey Kornilov admin 6/7/2011

You can use 'View as' Custom and ASP function Year() to display year only.
Example: http://www.aspwebpro.com/aspscripts/dates/year.asp