I have a date in the format dd/mm/yyyy
e.g
a=10/01/2000
How to I get "a - 3 days" in the same format (07/01/00)??
Thanks
Printable View
I have a date in the format dd/mm/yyyy
e.g
a=10/01/2000
How to I get "a - 3 days" in the same format (07/01/00)??
Thanks
What 'a 3-days' means?
What do you exactly do you want to do?
Do you use text boxes, or date pickers?
Michael Vlastos
Automation Engineer
Company SouthGate Hellas SA
Development Department
Athens, Greece
How about (as an example) :
'
Dim sTempDate as string
Dim dDate as date
'
sTempDate = "10/01/2000"
'
dDate = CDate(Format(sTempDate, "DD/MM/YYYY"))
'
dDate = dDate - 3
'
sTempDate = Format$(dDate, "DD/MM/YYYY")
'
MsgBox sTempDate
'
Chris Eastwood
CodeGuru - the website for developers
http://codeguru.developer.com/vb