Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - how 2 substract years from current date
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

how 2 substract years from current date
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
deepak View Drop Down
Newbie
Newbie
Avatar

Joined: 19 February 2007
Location: India
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote deepak Quote  Post ReplyReply Direct Link To This Post Topic: how 2 substract years from current date
    Posted: 19 February 2007 at 7:01am
if today is 19/feb/2007.. and if i substract 20 years from this .. i should get....19/feb/1987.. How to code this.. In ASP/MSaccess.
 
I am unable to find any date function.. which is outputting the required results.
Back to Top
Phat View Drop Down
Senior Member
Senior Member


Joined: 23 February 2003
Status: Offline
Points: 386 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Phat Quote  Post ReplyReply Direct Link To This Post Posted: 19 February 2007 at 9:18am
http://www.haneng.com/FunctionSearch.asp?s=DateAdd use -20 as well
Get a website that sells
Back to Top
bootcom View Drop Down
Senior Member
Senior Member
Avatar

Joined: 26 February 2005
Location: United Kingdom
Status: Offline
Points: 259 		Post Options Post Options   Thanks (0) Thanks(0)   Quote bootcom Quote  Post ReplyReply Direct Link To This Post Posted: 19 February 2007 at 5:23pm
Pretty much what you're wanting is:
 
DateAdd("yy", -20, now())
 
But look in to this closer, check out google and a cool beginner ASP resource, www.w3schools.com/asp.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.