storing a date with an ASP and MS Access

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.
avlaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sybeCommented:

'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
avlaAuthor Commented:
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
devthaCommented:

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

a.
0
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

avlaAuthor Commented:
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
miloaCommented:
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
sclaverieCommented:

 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development

From novice to tech pro — start learning today.