Comments by sophia kylie taylor

sophia kylie taylor 25-Mar-20 5:00am View

it is two hours from the first occurence

sophia kylie taylor 25-Mar-20 4:59am View

(select DateAdd(second,7200, '1900-01-01 00:00:00' + convert(int,(7200 * floor(datediff(HOUR, [LoadingDateTime], '1900-01-01 00:00:00' )/2)))) ReportTimestamp

could you help validate this script? I have been getting an error in this line when running the query

sophia kylie taylor 23-Mar-20 5:16am View

is there anyway i could get the data within the specific hour? When I tried to run the script, the earlier minutes wasn't capture since it depend on the date time i run the script. really appreciate your help.

sophia kylie taylor 19-Aug-19 23:50pm View

Is there anyway I could make the date time null-able?

sophia kylie taylor 14-Aug-19 23:35pm View

Deleted

|Emp Num |Time In |Time Out |
|--------|--------|---------|
| 123 | 6am | 3pm | this is what i want to look like on datagrid
| 123 | 6am | | this is what is currently happening
| 123 | | 3pm |

sophia kylie taylor 14-Aug-19 23:34pm View

Deleted

|Emp Num |Time In |Time Out |
|--------|--------|---------|
| 123 | 6am | 3pm | this is what i want to look like on datagrid
| 123 | 6am | | this is what is currently happening
| 123 | | 3pm |

Comments by sophia kylie taylor (Top 6 by date)