not considering join date and relieve date?

[Akina0929]

HI good morning all,

             I have calculated difference between two dates using following formula

date(Date(releavedate,'DD-MM-YYYY')-Date(joindate,'DD-MM-YYYY'),'DD') AS dtime

it's not considering  join date and  releave date it has to calculate that days also please help me

Thanking you,

[jonathandienst]

I think what you are after is:

Interval(Date#(releavedate,'DD-MM-YYYY') - Date#(joindate,'DD-MM-YYYY'), 'DD') AS dtime

Date# is the function that interprets a string and returns a date value. Date(..., 'DD') formatting will return the day of the month. I assume you want the number of days, so use Interval instead of Date for the outer formattng function.

[Anil_Babu_Samineni]

Why not simple Interval(releavedate-joindate,'DD') as dtime

And make sure to use the Date format environment should be your date format

[Akina0929]

HI Anil ,

It's also showing one day less please check the attached image. !

[Anil_Babu_Samineni]

Can you post the data on wall

[Akina0929]

Hi Anil,

please check the attached image.

[Anil_Babu_Samineni]

I am expecting Data like below

Date1, Date2

01-02, 03-03

[Kushal_Chawda]

try this

releavedate - joindate+1 AS dtime

[Akina0929]

HI anil,

   I am sending example data please find.

Thanking you,