The interesting thing is that if I check the: show time format it is fine, it is that any table that has a time in it is changed to hhmmss
Tom Hart ________________________________ From: TOM HART <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, August 22, 2011 6:00:15 PM Subject: [RBASE-L] - Re: Time format change The purpose of using the format command is to avoid messing with the formats, I know that your command would work, I just want to know why this is happening Tom Hart ________________________________ From: Bernard Lis <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, August 22, 2011 4:39:32 PM Subject: [RBASE-L] - Re: Time format change Hi Tom, Follow that command with set time hh:mm:ss Bernie Lis ----- Original Message ----- >From: TOM HART >To: RBASE-L Mailing List >Sent: Monday, August 22, 2011 5:31 PM >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 > >
