Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Date format		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

TerryG
Junior Member

United Kingdom
179 Posts
Posted - 07 August 2001 :  06:49:41  Show Profile
I am storing the date in a database using CDate(Now), but sometimes the date is stored as 8/3/01 11:27:16 AM and sometimes it is stored as 03/08/01 09:24:31, it is the latter I require being in the UK. Since all the PCs accessing my little app are on the Co network and all appear to be setup the same (Time/date is English GMT) can anyone tell me why sometimes the date is stored as mm/dd/yy, and others its dd/mm/yy. I thought this date came from the server which is just confusing me more now!!

GauravBhabu
Advanced Member

4288 Posts
Posted - 07 August 2001 :  11:05:28  Show Profile
Here is the solution:

inc_functions.asp


Find the following statement. This is within
function ReadLastHereDate(UserName)

TempLastHereDate = strToDate(rs_date("M_LASTHEREDATE"))

Replace the above statement as below:

TempLastHereDate = chKDate(rs_date("M_LASTHEREDATE")) & chKTime(rs_date("M_LASTHEREDATE"))

This will fix the date problem but time may be off for the members accessing from different time zones. I am working to fix that.


Share A Square at forumSquare


gauravbhabu

There is only one miracle...That is LIFE!

Edited by - GauravBhabu on 07 August 2001 11:16:43
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 07 August 2001 :  13:39:06  Show Profile  Visit HuwR's Homepage
quote:

Here is the solution:

inc_functions.asp


Find the following statement. This is within
function ReadLastHereDate(UserName)

TempLastHereDate = strToDate(rs_date("M_LASTHEREDATE"))

Replace the above statement as below:

TempLastHereDate = chKDate(rs_date("M_LASTHEREDATE")) & chKTime(rs_date("M_LASTHEREDATE"))

This will fix the date problem but time may be off for the members accessing from different time zones. I am working to fix that.


Share A Square at forumSquare


gauravbhabu

There is only one miracle...That is LIFE!

Edited by - GauravBhabu on 07 August 2001 11:16:43


What has this got to do with his auestion, he doesn't mention anything to do with forum dates/times.
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts
Posted - 07 August 2001 :  14:29:00  Show Profile
You are correct HUWR. Thanks for pointing it. I should have read it with more attention.

Share A Square at forumSquare


gauravbhabu

There is only one miracle...That is LIFE!
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts
Posted - 07 August 2001 :  14:48:08  Show Profile
TerryG.

What is the datatype of the field , where you are storing the date. Though as you have mentioned it seems to be Date/Time. Are you running application on the server or a copy of the application is installed on all the PC's?

Share A Square at forumSquare


gauravbhabu

There is only one miracle...That is LIFE!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07