Solved

storing a date with an ASP and MS Access

Posted on 1998-04-28
6
216 Views
Last Modified: 2013-12-25
I am trying to use the now() and/or getdate() functions in an ASP to initialize a text box with today's date. This works fine. I then use a regular HTML submit to pass that date through several ASP's before actually committing it to the database. It looks like it keeps the right format all the way until it writes it to my Access db.

Now I have a field date_out defined in Access as a date/time data type. When I look in how it is stored in db, Access gives it a default time (not even a date even though I have it formatted as short date only). This prevents me from searching on a date and just pulling out that field.

Does anyone have any idea why my date format would be lost in there?

An idea. That the submit of the form loses the date format and converts it to a string. Yet, Access will usually give an error if you try to assign a string to a date type, as it has when I try to explicitly use a string.

Any thoughts on this?

thanks. a.
0
Comment
Question by:avla
6 Comments
 
LVL 28

Expert Comment

by:sybe
ID: 1854341

'Use the ASP Date() function
Today = Date()


I use this function to checkmif a string can be converted to a date:

<%
Function CheckDate(str)
      strInput = str

      On Error Resume Next
      strOutput = CDate(strInput)

      If Err <> 0      Then
            CheckDate = nothing
      Else
            CheckDate = strOutput
      End If

End Function
%>

0
 

Author Comment

by:avla
ID: 1854342
Hi,

Try this


format(now(),date())    give 4/30/98
format(now(),format(time(),"HH:MM:SS AM/PM")) gives 12:22:08 P4






0
 
LVL 6

Expert Comment

by:devtha
ID: 1854343

Thanks for your input but that didn't seem to work either. All I got was type errors.

a.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Author Comment

by:avla
ID: 1854344
You said that you pass it through several ASP's...  Is there a way that you can test see if it will commit to the Access DB on the date's first creation from that first ASP?  There is a posibility that you are loosing the date format in the transition from one ASP to another.  That SHOULDN'T happen, but I have seen more weird things than that.  It could be that in the transitions, your date is becoming a string...

SHRUG..  dunno..  I'll try to do something like that and let you know what I find...
0
 

Expert Comment

by:miloa
ID: 1854345
Hey,

I have seen this problem many times before...in that ASP, are you sending the Date to the database via a sql command...i.e. as a text string...

If so, you need to have the Date enclosed within pound signs...so basically something liek this...

sqlString = "Insert into ThisTable (MyDate) VALUES (#" & Date() & "#)"

This is How I Do It...

Hope that worked...let me know, because this question deserves more points...
0
 
LVL 1

Accepted Solution

by:
sclaverie earned 50 total points
ID: 1854346

 I thought that it was still holding the date format but I guess not because when I used your suggestion, it actually worked. It turned out to be a rather simple answer.

 Thanks.

avla
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question