Date matching

[Khvreddy]

Hi,  I have start date and last date and other columns as well. I need to display data and time in start date column (3dates) same as last date column. I have used where condition, all the data getting disappeared. So I have removed time stamp and used where condition its working fine. 

I have no clue to resolve this issue. Your help is much appreciated.

[Or]

If they're in the same table, a simple WHERE [Start Date] = [End Date] should be fine.

If they're not in the same table, load the End Date table first and then use WHERE Exists([End Date],[Start Date]).

Both of these assume you're trying to do it in the Qlik load script, of course.

[Khvreddy]

Hi Or,

Thanks for your response. They are in the same table. If I use date(floor()) function its iss working fine. I feel there is some issue with the date format.

[Or]

If you think the issue is formatting, using the num() field should fix it, assuming all of the fields are recognized as dates (which seems to be the case since floor() works).  Of course, if you just need to match the dates without any timestamp element, then floor() is a fine solution.

[Khvreddy]

Hi Or,

Thanks for your quick response.

I have tried as you suggested using num function. No luck.

I have attached the script and output.

[Or]

That's not really a valid format for num() - you're trying to use Num() to format as a date which won't work. You could try doing that with the date() function instead if you're so inclined but if your issue is matching based on timestamps (with both a date and time element) that won't help since it'll just obscure the time aspect without actually removing it.

I'd suggest you format both of these fields as num(Field1) and num(Field2), place them in a table, and see if they're actually identical to the last digit. You might have a rounding issue with timestamps that are very slightly different.

Of course, all this again assumes that you need to match timestamps rather than just dates. If you just need to match dates, using floor() or dayname() works fine.