Link to home
Start Free TrialLog in
Avatar of xizor
xizorFlag for Australia

asked on

formating date

I want to format the date to loose the seperators:

eg: 7/11/2006 to 7112006

Idea on how?

cheers,

`Andy
ASKER CERTIFIED SOLUTION
Avatar of Raynard7
Raynard7

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
x =replace(7/11/2006,"/","")
MsgBox (Replace(Date, "/", ""))
msgbox(replace("7/11/2006","/","")) or MsgBox (Replace(Date, "/", ""))