Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Have "04/22/2005" need #04/22/2005#...help.

Status
Not open for further replies.
Vcscwi

Vcscwi

Programmer
Jan 15, 2004
57
US
I'm not findig the function I need to convert a string to a date.

I have s="04/22/2005", but need it to be a date.

I know how to do it in VFP but my VBA mind isn't working today.

Thanks!
 
Sort by date Sort by votes
Take a look at the CDate function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
350
combo
combo
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
350
IrishJim
IrishJim
DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
6K
Norman Sherlock
Norman Sherlock
Aurillius
  • Locked
  • Question
Help with Unzipping a file and saving to a folder in Excel VBA
Replies
1
Views
595
Aurillius
Aurillius
SoLost1
  • Locked
  • Question
XIRR in Access HELP A NOOB PLOX!! 2
Replies
16
Views
669
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top