You can use ROUND function in your SQL.
>Thank You Nadya,
>
>The day's are no longer truncated but its still displaying TotHours with 4 decimal places. But thats ok, its just minor - this project is kinda being rushed so I can fix that later.
>
>Thanks again!
>
>
select padr(cdow(datein),12) as DayIn, 00.00+Minutes/60 as TotHours from TimeCard
If it's not broken, fix it until it is.
My Blog