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
