# Past date calculation

Hi, please help, can anyone share a good subroutine to calculate a past date from a date variable? say if I want to find out what the date was 25 months ago or 38 days ago from today. Thanks.

## Comments

• : Hi, please help, can anyone share a good subroutine to calculate a past date from a date variable? say if I want to find out what the date was 25 months ago or 38 days ago from today. Thanks.
:
:
You can use Datediff function for this situation.In reality the method you demand depends on your requirements...
• : Hi, please help, can anyone share a good subroutine to calculate a past date from a date variable? say if I want to find out what the date was 25 months ago or 38 days ago from today. Thanks.
:
:
The .NET date object has built in functions ...

[code]
' Get Current Date
Dim dt As Date = Date.Now.Date

' Subtract 25 Months
dt = dt.AddMonths(-25)

' Subtract 38 Days
dt = dt.AddDays(-28)
[/code]

• : : Hi, please help, can anyone share a good subroutine to calculate a past date from a date variable? say if I want to find out what the date was 25 months ago or 38 days ago from today. Thanks.
: :
: :
: You can use Datediff function for this situation.In reality the method you demand depends on your requirements...
:
Thank you Brkevr for your comments.
• : : Hi, please help, can anyone share a good subroutine to calculate a past date from a date variable? say if I want to find out what the date was 25 months ago or 38 days ago from today. Thanks.
: :
: :
: The .NET date object has built in functions ...
:
: [code]
: ' Get Current Date
: Dim dt As Date = Date.Now.Date
:
: ' Subtract 25 Months
: dt = dt.AddMonths(-25)
:
: ' Subtract 38 Days
: dt = dt.AddDays(-28)
: [/code]
:
:
:
Hi Iwilld0it, you know what? you really have made my day, thank you very much, that's exactly what I was looking for and it works. Just how did you figure that out?
• : : : Hi, please help, can anyone share a good subroutine to calculate a past date from a date variable? say if I want to find out what the date was 25 months ago or 38 days ago from today. Thanks.
: : :
: : :
: : The .NET date object has built in functions ...
: :
: : [code]
: : ' Get Current Date
: : Dim dt As Date = Date.Now.Date
: :
: : ' Subtract 25 Months
: : dt = dt.AddMonths(-25)
: :
: : ' Subtract 38 Days
: : dt = dt.AddDays(-28)
: : [/code]
: :
: :
: :
: Hi Iwilld0it, you know what? you really have made my day, thank you very much, that's exactly what I was looking for and it works. Just how did you figure that out?
:

I've been programming .NET professionally for nearly 4 years, so you tend to pick up little tricks here and there.

Sign In or Register to comment.

#### Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!