May be Date mismatch happening !

[#1]

This is what I am doing, but noit matching with my required count, please suggest something

Because I dont know whether it is considering After 12'OAM clock value or not.

(date(Today(),'YYYYMMDD')- (Date(field,'YYYYMMDD')+ day(15)

[jonathandienst]

You don't need the format statements (Date()) here, but what are you trying to do with Day(15)? This will return the day of the week for the date 15 days from the date epoch start (1/1/1900) -- but I am pretty sure that is not what you need.

Perhaps this is what you need:

     Today() - Floor(field) + 15

[#3]

Thanks Jonathan.

I just want difference between dates,but I am sure , problem is here

because SQL script I have rechecked , that's correct.

I am confuse for Date format bcoz,by default date format in SQL Server is different than that in Qlikview.

That's why may be count is getting mismatch.