Strange calculate

[johnan]

Hi, i have (i think) a date like this:

1754-02-16 00:00:00

How can i calculate in QV so it's shows 411 days??

Or
1753-11-14 00:00:00 = 317 days
I'm stucked here bigtime 🙂

[Taoufiq_Zarra]

@johnan 

and 411 days or 317 corresponds to what ?

[johnan]

I'll be back, i don't even know yet 😂

I could be todays date, it's regardning Exipredays

[johnan · Accepted solution]

Hi, okay this is the solution, It comapres the lowest datetime in MS-SQL (1753-01-01) to 1753-11-14, and it's 311 days.

Strange way to calculate, but it works 🙂