Date question

[Sigal Laniado]

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

[Dr_Michael]

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

[Chris Eastwood]

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