User Profile

Collapse

Profile Sidebar

Collapse
Holdstrong
Holdstrong
Last Activity: Feb 12 '07, 05:11 AM
Joined: Feb 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Holdstrong
    replied to Format input date for passing to database
    in ASP Classic
    Thanks for the help. I certainly have a much better handle of the problem now thanks to a lot of you.

    Here was my solution.

    I run the following code at the top of my page (thanks to person who posted this in the linked thread):

    Code:
    correctDate = day(request("mydate1")) & "-" & monthName(month(request("mydate1"))) & "-" & year(request("mydate1"))
    ...
    See more | Go to post

      Leave a comment:

    • Holdstrong
      replied to Format input date for passing to database
      in ASP Classic
      Ok, my brain is slightly fried today and I have to leave this to work on other stuff now, but I think I have a test page up which at least demonstrates that the ASP page is in fact translating dates correctly and that it IS possible to convert the dates entered into the form before passing them on.

      Here is the page: Test Page

      I used the suggested correctDate code supplied in the linked thread.

      Now, unless...
      See more | Go to post

        Leave a comment:

      • Holdstrong
        replied to Format input date for passing to database
        in ASP Classic
        Thanks for the move :)

        I am going to set up a replicate page without our login procedures to continue to work on this today and hopefully give potential helpers an actual working example to see....
        See more | Go to post

          Leave a comment:

        • Holdstrong
          replied to Format input date for passing to database
          in ASP Classic
          Yeah, I think this has definitely gone from an Access issue, to an ASP issue.
          See more | Go to post

            Leave a comment:

          • Holdstrong
            replied to Format input date for passing to database
            in ASP Classic
            Definitely getting close here, I can taste it! Hahaha.

            I am using a Date/Time field in the Db, we just used a text field to test something out.

            So, the code you supplied above would seem to solve the problem for something like today's date... is there anyway to do that to the info being input by the user into the form (which is not always today's date)

            Maybe run a function onsubmit that converts "mydate1"...
            See more | Go to post

              Leave a comment:

            • Holdstrong
              replied to Format input date for passing to database
              in ASP Classic
              Hi there!

              I am just using today's date as an example. This is an app where users will enter dates into a form, so those dates change and are input by the user. (it is a calendar app where people enter the dates they will be out of the office)

              Unfortunately my coding knowledge is limited so I just had to look up what combo boxes were, but it doesn't seem like that would solve the issue. It has also been suggested that...
              See more | Go to post

                Leave a comment:

              • Holdstrong
                replied to Format input date for passing to database
                in ASP Classic
                I may be getting ahead of myself here, but to recap:


                Access is converting dates I send to it in the mm/dd/yyyy format and is storing them as dd/mm/yyyy.

                However, if I send it an unambiguous date, such as 7-feb-2007 (dd/mmm/yyyy) or 2007/2/7 (yyyy/mm/dd) Access does receive and store the info correctly.

                This appears to be a problem with a regional setting somewhere in my hosting solution. Since...
                See more | Go to post

                  Leave a comment:

                • Holdstrong
                  replied to Format input date for passing to database
                  in ASP Classic
                  Thanks again!

                  #1) The site is hosted by a third party company, so I suppose I can call them up and work through their tech support chain to try to get them to test out all of the machines relevant to our site. I have the feeling this might be a fruitless adventure but I will try

                  #2) If I send an unambiguous date string such as 7 Feb 2007 it is in fact translated correctly. So when I type in 7 Feb 2007 in both the...
                  See more | Go to post

                    Leave a comment:

                  • Holdstrong
                    replied to Format input date for passing to database
                    in ASP Classic
                    Thanks for the follow ups. Great troubleshooting step by the way.

                    Ok so I created a test field in my Access Db and made sure it was set to text. I then altered my code slightly to pass the "mydate1" value from the user form to that text field instead of the usual Date/Time field and viola!

                    2/7/2007 is properly received and stored in that "testtext" field as the text 2/7/2007

                    Whereas...
                    See more | Go to post

                      Leave a comment:

                    • Holdstrong
                      replied to Format input date for passing to database
                      in ASP Classic
                      Hi Mary, thanks for the response.

                      The tutorial you linked may or may not help... but I am pretty new to this and I really didn't understand what it was trying to teach me. It looked like it was telling me to use m/d/y for my strings and saying that you can format() a string before passing it to the Database?

                      It wasn't clear to me and I didn't see any examples. But my strings "mydate1" and "enddate"...
                      See more | Go to post

                        Leave a comment:

                      • Holdstrong
                        started a topic Format input date for passing to database
                        in ASP Classic

                        Format input date for passing to database

                        Hi there, I have done a few hours worth of searches on this and have spent the better part of tonight reading other threads about it... but yet the problem is still unclear to me.

                        I am hoping if I present my specific issue that someone can offer a solution or explanation in a way that clicks with me.

                        My site is being hosted by a third party. I have a form that requests a date from the user and then stores that date...
                        See more | Go to post
                        No activity results to display
                        Show More
                        Working...