This content has been marked as final. Show 2 replies
You're adding dates and strings.
Not sure what all of your data types are but this might work for your needs.
dateadd('hour',datepart('hour',[Time of Day]),[Date])
[Aaron welcome to the 'helpers' forum. Good to have you contributing. Thx.]