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

Date Format

P: 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
Share this Question
Share on Google+
9 Replies


damonreid
Expert 100+
P: 114
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

Expert 100+
P: 634
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

P: 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

Expert 100+
P: 634
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

P: 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

P: 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
Expert 100+
P: 1,923
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

P: 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

P: 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.