DavidT_macktool
Well-known member
I have an SQL dataset of time card records. I need to compute direct labor based on the "hours" value in this dataset.
I need a function - simple if statement that does this:
if (time card date) = saturday or sunday then
hours = hours * 1.5
end if
We pay overtime on weekends.
How do I determine if the Time Card Date is a Saturday or Sunday?
Thanks for reading,
I need a function - simple if statement that does this:
if (time card date) = saturday or sunday then
hours = hours * 1.5
end if
We pay overtime on weekends.
How do I determine if the Time Card Date is a Saturday or Sunday?
Thanks for reading,