Javier: In your "insert" statement, you are inserting the variable vhr_reg_t into the labor_date column, aren't you? That's the "real" variable you defined. I don't see v_date being loaded into that table.... Boy, you owe TONS to the "duh" pot....
Karen > SET VAR vhr_reg_t REAL = 100.0 > SET VAR vhr_ot_t REAL = 100.0 > SET VAR vhr_2times_t REAL = 100.0 > SET VAR vhr_all_t REAL = 300.0 > SET VAR vinc_date DATE = '10/05/2007' > SET VAR vmonth = (TMON(.vinc_date)) > SET VAR v_date TEXT = (.vmonth + ', ' + CTXT(IYR(.vinc_date))) > > INSERT INTO temp_graph1 + > (labor_sort, + > labor_date, + > labor_hr_reg, + > labor_hr_ot, + > labor_hr_2times, + > labor_hr_all) + > VALUES + > (1,.v_date,.vhr_reg_t, .vhr_ot_t, .vhr_2times_t, .vhr_all_t)
