you are seeing the result of your TIME FORMAT setting This setting sets how time will be displayed , not how it is stored.
if you want to see the time on your form in a different format just put a date/time picker on your form for that column make it read only. set it up for time with your desired display format. It will not display correctly in design mode. Test it in enter and edit mode. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 1:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: date time You folks have been very helpful. This table is a permanent table but it is used as a temporary holding table. I want to every 10 to 60 seconds update or add to other tables with this information. 1) Do you think I should put the update CMD file in the main menu form timer in my application? 2) The #NOW function uses 24 hour time. Do you see any problem with that since it is primarily for just this temporary information? James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 1:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: date time Dennis, Would that be true if the editing takes place in the table? I do not think so! How about a separate form that would not equate the field with the variable #NOW? James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, February 26, 2014 12:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: date time James, If anyone goes back and edits the data, the timestamp will be updated. If that is what you want you are golden. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 12:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: date time Karen, Sometimes the old fashioned way works better. Now I got what I want. Thanks for the tip. James Belisle Making Information Systems People Friendly Since 1990 From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Wednesday, February 26, 2014 12:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: date time Or you can do it the old fashioned way and define a form variable: DateTimeCol = .#NOW This will only update if the row has been modified or inserted Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Feb 26, 2014 12:23 pm Subject: [RBASE-L] - RE: date time All right, let us put the two different pieces in one post. It might help clarify things. So that the user sees the time on the form, place the LED or analog clock on the form. It will click off the seconds, but won't do anything for the database entry. You need to use .#NOW when you insert the row as part of the data string when you post the row to the table. This is in the button eep that you use to save the row. Albert
