Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

date formula in where clause

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)

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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

2 Replies
Partner
Partner

I think you are using the wrong Style in convert function. Try this:

CONVERT(DATETIME, '2019-01-01 00:00:00',120)

Highlighted
Contributor III
Contributor III

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