By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

How to use standard date format

P: 145
Hi to all,
I unable to solve this problem.
Iam using vb6.0 anb msaccess 2003
Iam uploading data from various excel.The problem is with the date format only while uploading the date format changing as

Date format in access dd/mmm/yyyy

while uploading date changes like
01/07/2008 (dd/mm/yyyy) - 07/01/2008

after 12 th date its working fine

and this database in the multiuser path.each user having different date format
i dont know how to handle can any one advice me.

it becoming a black problem for me . please
it urgent
thanks in advance
Jul 28 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 903
Have you tried using the Format function. Such as

Expand|Select|Wrap|Line Numbers
  1. fmtDate=Format(DateField,"Short Date")
Or use any of the other format options for date. Check out MS link
Format function

Jul 28 '08 #2

Expert Mod 15k+
P: 31,263
Literal DateTimes and Their Delimiters (#) may provide some insight as to why the dates are swapping days and months. It stops being a problem after the twelfth of the month as a number greater than 12 can never be mistaken for a month so is treated correctly as the day.
Aug 4 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.