Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
chrisellis
Not applicable

IntervalMatch

When using IntervalMatch does it matter how dates are formatted ?

For example when I look at the data I have one that looks like this 07 September 2015 that I am checking to see if it exists between 2 dates that look like this 07-Sept-15.

I have tried some formatting such as Date#("Date",'DD MMMM YYYY') and it does not seem to help.

Any suggestions much appreciated.

Chris

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: IntervalMatch

As long as the two dates are read as dates, formats don't matter for interval match to work properly. Is 07-Sept-15 read as a date?

2 Replies
sunny_talwar
Not applicable

Re: IntervalMatch

As long as the two dates are read as dates, formats don't matter for interval match to work properly. Is 07-Sept-15 read as a date?

pimjansen1
Not applicable

Re: IntervalMatch

Hi Christopher,

In my experience it is a best practice to convert the date-formats to numeric fields.

That way the intervalmatch wil work.