topic Re: find Date difference after Splitting Date from Timestamp in QlikView

find Date difference after Splitting Date from Timestamp

Anonymous — Wed, 13 Jun 2018 13:53:39 GMT

Dear Experts,

Please suggest on this.

I executed below script but the date is getting when doing the Difference, its showing the Decimal.

Re: find Date difference after Splitting Date from Timestamp

Anonymous — Wed, 13 Jun 2018 15:38:33 GMT

Hello, Achok!

If you are trying to get the difference in days, try this:

Interval(Date - Date1, 'DD') As Diff

Re: find Date difference after Splitting Date from Timestamp

vishsaggi — Wed, 13 Jun 2018 15:54:48 GMT

Check this?

Re: find Date difference after Splitting Date from Timestamp

Anonymous — Thu, 14 Jun 2018 04:34:40 GMT

Thanks for your response Danial / Vishwarath,

Yes. I tried with this. still the value is not accurate.

Please find the screenshot.

Re: find Date difference after Splitting Date from Timestamp

vishsaggi — Thu, 14 Jun 2018 16:33:46 GMT

What you want to see in NewYes column? I mean what is your expected value and why? Your NewYes is based on what the Diff column values are right? So if Diff has 0's what values does NewYes should have?