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

chandru8
100+
P: 145
Hi to all,
I unable to solve this problem.
Iam using vb6.0 anb msaccess 2003
Problem:
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


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

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

cheers,
Jul 28 '08 #2

NeoPa
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.