Member Avatar for scialom

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

  • 4 Contributors
  • 4 Replies
  • 141 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by oscarsierra
Member Avatar for 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?

Member Avatar for scialom

I meant 3 days but it's the same :p
Thanks, it helps

Assaf

Member Avatar for radharadha

If u r using VbScript simple gice CDate("urDate")-3

Member Avatar for oscarsierra

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.