Thanks for your help. I seem to have fixed this now. I did care about time but only the hour !
So it's a weird format because it's '31/01/2018 01:00:00:00'
Would people normally do this or would they concatenate a Date and and Hour column to make a key.
I am very new to learning QLik so apologies. I'm just learning how to associate tables in the script at the moment and am having troubles with blasted dates