find Date difference after Splitting Date from Timestamp

[Anonymous]

Dear Experts,

Please suggest on this.

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

[Anonymous]

Hello, Achok!

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

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

[vishsaggi]

Check this?

[Anonymous]

Thanks for your response Danial / Vishwarath,

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

Please find the screenshot.

[vishsaggi]

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?