Subtracting one day from date

[PipBoy808]

I thought this was one of those things I knew how to do, but I was wrong.

How does one subtract a single day from a date in VBA?

Dim MyDate as Date
 
MyDate = "03/06/2014"
 
MyDate = MyDate - 1 'error

Help would be much appreciated!

 

[KenU]

@PipBoy808,

Replace the last two lines shown above with the following:
MyDate = DateSerial(2014, 3, 6) - 1

It will then return the date of the previous day. If you need to keep the entered date and calculation separate, then you can use the two line approach as you have done, but replace the string with the DateSerial function.

Hope that helps.

Regards,
Ken

 

[Debraj]

Hi pipboy..

Your code is perfectly working fine in here..



Can you please confirm.. what error you are facing..