Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. 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

Re: date formula in where clause

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
Highlighted
Partner
Partner

Re: date formula in where clause

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

Re: date formula in where clause

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