tulnetdotcom
Posts: 26
|
| Posted: 03/04/2005, 8:50 AM |
|
I am using ASP,MSAccess and IIS for the application.
While inserting the record with date field, date format is dd/mm/yyyy but after inserting the record it appears as mm/dd/yyyy. Can you tell me why this is happening .
I checked every thing from frontend to backend. Everywhere the format is dd/mm/yyyy.
Thanks !!!
|
 |
 |
peterr
Posts: 5971
|
| Posted: 03/04/2005, 10:21 PM |
|
Please make sure that you specify in Project Settings the date format that you want to display.
Also the Connection -> Server should contain the Date Format "yyyy-mm-dd HH:nn:ss" for MS Access (I think).
Lastly, verify that the database field type is "Date/Time" and CCS filed type is "Date".
You may also want to check how the date appears in the database.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Felipe
|
| Posted: 03/11/2005, 6:42 AM |
|
i had the same problem and i´ve tried to change everywhere that was possible to change date configuration, but the only way that worked fine was to change the field to "date" type, then select the tye o date bellow, like " dd/mm/yyyy" and then put the field back to "text".... that worked for me and thats how I still make dates work.
|
|
|
|
pnjones
Posts: 42
|
| Posted: 03/16/2005, 8:46 AM |
|
I had the same problem trying to use the european date format dd/mm/yy it works fine from jan till mar then the early march dates were reported as feb , ie swapping the months to the us format. I have had no replies to my post
_________________
Regards
Pat |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/16/2005, 3:10 PM |
|
I've seen this issue a few time but not too often. I think that if all your CCS project configuration looks good then it may be a problem with the server configuration (regional settings) or page encoding. Just an idea.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dataobjx
Posts: 181
|
| Posted: 03/17/2005, 5:42 AM |
|
This can also occur because of your LCID setting...
The LCID property uses the location identifier number to access information on display format issues, such as currency, date, and time, that are specific to a location or region. The location identifier number uniquely defines a geographic location or region. For example, the location identifier number for France is 1036.
Example demonstrates setting the locale to British English and using the VBScript FormatCurrency method to display the value 125 as currency with the £ symbol
'Session.LCID = 2057
'Dim curNumb
'curNumb = FormatCurrency(125)
'Response.Write (curNumb)
'Rem this line out if located within the USA.
'One resource having a listing of LCID's is located at the URL below;
'http://www.123hostnow.com/articles/LCID.asp?LCID=7177
'Session.LCID = 7177 'South Africa
'Session.LCID = 3081 'Australia
'Session.LCID = 1036 'France
'Session.LCID = 2057 'UK
_________________
www.DataObjx.net
www.mydigitalapps.com |
|
|
|
S_A
Posts: 29
|
| Posted: 03/18/2005, 11:03 PM |
|
tulnetdotcom
In my case I tried all of the above (all very valid stuff) but the error in my case was that as pointed out by Peterr - where in the server connection the data format must not be dd/mm/yyyy. Try the others until you get what you need. This worked for me after hours of checking.....
Good luck,
Scott.
|
|
|
|
S_A
Posts: 29
|
| Posted: 03/18/2005, 11:13 PM |
|
tulnetdotcom
One last point - if that still does not do it, are you sure that the regional settings on the SERVER are correct?
In order to give a crude indicator you could upload a simple ASP script to the server and view what you get: -
In it's most basic form try this code in an otherwise empty text file named for example, checkdate.asp and run it:-
<%
response.write "ASP is working OK if you can see this message: Today's Date is:" & Space(1) & Date()
%>
If you want to compare the LCID settings try this one:-
<%
'United States LCID
Session.LCID = 1033
Response.Write Date() & "<br />"
'English - LCID
Session.LCID = 2057
Response.Write Date() & "<br />"
%>
You will then see the date displayed accordingly.
Not sure if this will help but it gave me the confidence that the server was setup correctly as it is the server date format that matters here.
Scott.
|
|
|
|
