Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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...

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page