Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

add years to formatdatetime(now(),2)

Posted on 2005-03-27
1
Medium Priority
?
284 Views
Last Modified: 2008-03-06
Hi experts

How to add 10 years on my formatdatetime (now(),2)

I tried this

NextYear = formatdatetime(now(),2) + 10

it did not work

any tip ?

Thx
0
Comment
Question by:humer2000
1 Comment
 
LVL 55

Accepted Solution

by:
Ryan Chong earned 2000 total points
ID: 13639651
try using DateAdd function? like:

NextYear = formatdatetime(DateAdd("yyyy", 10, now()),2)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question