Hi All,
I am getting a rabdom date from the db. Now for each date that I get I have to reduct 3.
For example:
I get 02/12/2005
The new date supposes to be: 30/11/2005
How can I do that?
Thanks,
Assaf
scialom
0
Newbie Poster
Recommended Answers
Jump to PostAre you asking how you can subtract 3 months from a date? Pretty easy, use the vbscript dateadd function. I know it sounds backwards, but if you add a negative number you'll be subtracting in essence. In your case you would do it this way dateadd("m", -3, 02/12/2005)
Makes …
All 4 Replies
nicentral
Are you asking how you can subtract 3 months from a date? Pretty easy, use the vbscript dateadd function. I know it sounds backwards, but if you add a negative number you'll be subtracting in essence. In your case you would do it this way dateadd("m", -3, 02/12/2005)
Makes sense?
scialom
0
Newbie Poster
I meant 3 days but it's the same :p
Thanks, it helps
Assaf
radharadha
0
Newbie Poster
If u r using VbScript simple gice CDate("urDate")-3
oscarsierra
0
Newbie Poster
What does you query look like ??
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.