Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Date Question

Discussion in 'Information Technology' started by metaltecks, Jul 28, 2006.

  1. metaltecks

    Expand Collapse

    I have a form that gets filled with patient data. There are two fields, start
    reg time and end reg time. Both of this fields are Date/Time fields, ex.
    5/10/2006 3:10:40 PM.

    When the registration begins, the users click on the save button, and this
    automattically populates the start reg time with the current date/time. When
    the registration is completed, they hit the completed button to also populate
    the current date and time.

    My question is that sometimes I need to edit the time, but when I pull a
    query of all the patients that need to be changed, I can't change the date. I
    can change the time, but not the date. I've even tried going into the
    registration table and manually adding the date, but same thing, can only
    enter the time.

    Any suggestions on how I can add the date?
  2. Loading...

Share This Page