Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-18 : 09:51:31
|
| sanjay writes "Hi everybodyi am working in VB/ACCESS. i want to handle the dates. my date format should be common throught my programm. it should not change if user change the date setting in regional settings of the systems.how to maintain this." |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-06-18 : 22:00:02
|
| Hi sanjaynot sure exactly what your question is - but if I was you, I'd be passing any date you receive through a format function before storing it in access....egIf IsDate(varUserData) then rst.Fields("StartDate") = CDate(Format(varUserData,"yyyy mmm dd hh:nn:ss"))End if...etcThat way you shouldn't get it mixed up - preferably you should probably write back to the user the date in a common format so they can check that you've understood what they've typed in.Personnally I always use "24 Jan 2002" as a nice compromise. Users tend to understand it and it's easy to resolve. (But I'm in Australia)HTH--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 06/18/2002 22:01:15 |
 |
|
|
|
|
|
Problem with Date format