Discussion board where members can get started with Qlik Sense.
I think there is an issue with this formula in my where clause. can anyone see an issue with this??
APPT_DATETIME >= CONVERT(DATETIME, '2019-01-01 00:00:00',102)
(the format of the field is YYYY-MM-DD 00:00:00.000000)
thanks for you help. I realised i was connecting to an oracle database so have to use the TO_DATE function
View solution in original post
I think you are using the wrong Style in convert function. Try this:
CONVERT(DATETIME, '2019-01-01 00:00:00',120)