469,917 Members | 1,661 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

Date Format

15
Hi all,

How do you make the date format comply with dd/mm/yy?

When I test dates entered it changes 13/07/1968 to 07/13/1968 (to place month first) but if you type 02/03/1968 where 03 is the month it assumes 02 is the month and does not switch them causing errors.

Also I want the year to be 2 digits (07 representing 2007) but sometimes if I enter a date as 13/02/07 it assumes the year to be 2013 returning 02/07/2013. Why can't the dates do what I want them to do?

I have spent hours on this and am totally bummed out.

deejow
Aug 2 '07 #1
9 3140
damonreid
114 Expert 100+
Is it possible to use the dd/mmm/yy format thus getting around this problem?

Another solution is to add a calendar control to the onclick for each date field; this will bring up a calendar and allow them to select a date from that?
Aug 2 '07 #2
MikeTheBike
637 Expert 512MB
Hi

This is a perennial problem when you local computer date setting is UK ?? ie dd/mm/yy as opposed to Microsofts (US) default of mm/dd/yy.

The solution will depend on where you entering the date and how are you are using them from there?

MTB
Aug 3 '07 #3
Twanne
65
I've been searching for the solution of this problem for a very long time. Now I made a "stupid" function that switches the dates day and month if the day is smaller than 12.

Expand|Select|Wrap|Line Numbers
  1. Public Function dateFormat(datum) As String
  2. Dim test As Integer
  3.         days = Format(datum, "dd")
  4.         months = Format(datum, "mm")
  5.         years = Format(datum, "yyyy")
  6.         If (day < 13) Then
  7.             test = days
  8.             days = months 
  9.             months = test
  10.         End If
  11.         dateFormat = days & "/" & months & "/" & years
  12. End Function
The when you have the string you can put it bacj in date format with CDate() or somthing
Aug 3 '07 #4
MikeTheBike
637 Expert 512MB
This is a perennial problem when you local computer date setting is UK ?? ie dd/mm/yy as opposed to Microsofts (US) default of mm/dd/yy.

The solution will depend on where you entering the date and how are you are using them from there?
I still think we need to know the aswers to these two questions !

MTB
Aug 3 '07 #5
Twanne
65
I understand what you mean but I have searched for a few days (maybe weeks) and I couldn't find it. So I've solved it this way
Aug 3 '07 #6
deejow
15
Is it possible to use the dd/mmm/yy format thus getting around this problem?

Another solution is to add a calendar control to the onclick for each date field; this will bring up a calendar and allow them to select a date from that?
Mmmmm. I like the sound of the calendar control. How do I create such a blessed thing?

deej
Aug 4 '07 #7
puppydogbuddy
1,923 Expert 1GB
Mmmmm. I like the sound of the calendar control. How do I create such a blessed thing?

deej
Here is a link to a ready made calendar using an Access form, which has several advantages over an ActiveX. Step by step instructions are provided in the link.

http://allenbrowne.com/ser-51.html
Aug 4 '07 #8
deejow
15
Hi

This is a perennial problem when you local computer date setting is UK ?? ie dd/mm/yy as opposed to Microsofts (US) default of mm/dd/yy.

The solution will depend on where you entering the date and how are you are using them from there?

MTB
Yes,

It is simple when you know where to look. The problem was fixed by going to: Control Panel > Regional and Language Options > (tab) Regional Options - select your region correctly then > (button) Customise > (tab) Date - change options to suit your needs.

An input mask of 99/99/99 was also used where '9' indicates a number from zero to 10 is required.

Thnx to all for helping.
Aug 4 '07 #9
deejow
15
Here is a link to a ready made calendar using an Access form, which has several advantages over an ActiveX. Step by step instructions are provided in the link.

http://allenbrowne.com/ser-51.html
That is one of the coolest things I have ever seen...erm...I need to get out more.

Thnx dude
Aug 4 '07 #10

Post your reply

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

Similar topics

15 posts views Thread by Simon Brooke | last post: by
4 posts views Thread by Richard Hollenbeck | last post: by
5 posts views Thread by Macca | last post: by
12 posts views Thread by Assimalyst | last post: by
20 posts views Thread by andreas | last post: by
30 posts views Thread by fniles | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.