Tom, Does this just happen when you format #time or when you format any time variable? If it does not do it when formatting a different time variable then you can see where I'm going for a solution! If it does it with any time variable then I think you should be working with RBTI on a solution. What version of R:Base?
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Monday, August 22, 2011 6:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Time format change If I just do this: set var vNextrans text = (.vEmpID+(format(.#date,'yymmdd'))) nothing happens to the date or time format To be clear I do the following: dis database con database check time format , everything fine set var vNextrans text = (.vEmpID+(format(.#date,'yymmdd'))+(format(.#time,'hhmmss'))+'T') check time format, it is set to hhmmss not hh:mm:ss dis database con database check time format , everything fine set var vNextrans text = (.vEmpID+(format(.#date,'yymmdd'))) check time format, everything fine It has to be the added (format(.#time,'hhmmss')) that is the problem Tom Hart ________________________________ From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, August 22, 2011 4:48:35 PM Subject: [RBASE-L] - RE: Time format change This certainly should not be happening. There should be no coupling between the two. Comment out the ???offending??? line and see if it still happens. I suspect something else is changing the format. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of TOM HART Sent: Monday, August 22, 2011 4:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Time format change I'm stumped, how does this variable change the time format in my database set var vNextrans text = (.vEmpID+(format(.#date,'yymmdd'))+(format(.#time,'hhmmss'))+'T') This set var works but after I run it the time format is changed to hhmmss in my database, everywhere I have a time value it is this format. It does not however change the data format. Am I missing something because the reason I use this is because Razz had shown examples on using this. Tom Hart
