Thanks kendash 
Am still struggling to get it to work, cant just use date encase there is a past midnight sale from day before…
Workperiod ID would be nice in ticket table LOL 
Get an exception error…
Tried @QMcKay format and split script
Get 2016-01-02 19:15:35.583
but with t.[Date] > '@3'
Where @3 is the parameter/value input and t. is the Tickets table, to the SQL script throws an error.
If i use '2016-01-02 19:15:35.583' I still get an error so something wrong somewhere…
Thats the format in the table… 
