Page 1 of 1

Windows 8 date format

PostPosted: Tue Aug 12, 2014 3:35 pm
by BRobinsonS
I don't use Windows 8 but I have customer who does.
Recently installed a NB program I developed which works find on Windows 7
I have date fields in the MDB file.

Using:
dbpPopupDateSelector "Left=250;Top=100;InitialDate=;DateFormat=m/d/yyyy" "[AddrBook.Contacts.ActiveDate]"

Field validation mask for date field
!90/90/0000

Tried changing date format in Control Panel for Windows 8 but still does not paste the month/day/year correctly.
Again, it works fine in Windows 7.

I also noticed although I changed the Windows Date format that the date field I have at the bottom of a report shows the format line 2014-08-12 but on Windows 7 shows as expected 8/12/2014 ???

Any suggestions?

Re: Windows 8 date format

PostPosted: Tue Aug 12, 2014 4:07 pm
by Gaev
Brian:

Using:
dbpPopupDateSelector "Left=250;Top=100;InitialDate=;DateFormat=m/d/yyyy" "[AddrBook.Contacts.ActiveDate]"
... try ...
Code: Select all
dbpPopupDateSelector "Left=250;Top=100;InitialDate=;DateFormat=m/d/yyyy" "[selectedDate]"
AlertBox "selectedDate" "[selectedDate]"
... which will tell you the format of the date returned by the Date Selector ... unrelated to the database.

Post your results here.

Field validation mask for date field
!90/90/0000
... not sure where you are using this (if the result of the Date Selection is saved directly in a database filed of the current record)

Tried changing date format in Control Panel for Windows 8 but still does not paste the month/day/year correctly.
In my experience ... on a Windows XP machine ... and whatever version of Access/Jet DB Engine that came with it ... the DB engine did not honor the the date format in Control Panel for Windows ... always used m/d/y

Re: Windows 8 date format

PostPosted: Wed Aug 13, 2014 7:43 am
by BRobinsonS
... try ...

Code: Select all
dbpPopupDateSelector "Left=250;Top=100;InitialDate=;DateFormat=m/d/yyyy" "[selectedDate]"
AlertBox "selectedDate" "[selectedDate]"

... which will tell you the format of the date returned by the Date Selector ... unrelated to the database.

Post your results here
.
The selected date shows right, but I can't test it on Windows 8 because I don't have a Windows 8 computer.

Field validation mask for date field
!90/90/0000

... not sure where you are using this (if the result of the Date Selection is saved directly in a database filed of the current record)


I was using this for Text Entry field (which is attached to Date field variable in DB field) under Style.
Perhaps I don't need it because I am using the dbpPopupDateSelector.
I do display the format next to the field so if a customer is entering the date by hand know how to enter the date.

I am visiting the customer (fortunately she is local) so I will try the app removing the Validation (Style) on the Text Entry field.
I am limiting the text entry to 10 characters or maybe I should leave it open.
On Windows 7 where I am developing the app, the database doesn't give me any errors.

Re: Windows 8 date format

PostPosted: Wed Aug 13, 2014 7:51 am
by Gaev
Brian:
The selected date shows right, but I can't test it on Windows 8 because I don't have a Windows 8 computer.

Of course, we need to see what Windows 8.x is doing ... so check it out on customer's machine.