Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Why not simple Interval(releavedate-joindate,'DD') as dtime
And make sure to use the Date format environment should be your date format
HI Anil ,
It's also showing one day less please check the attached image. !
Can you post the data on wall
Hi Anil,
please check the attached image.
I am expecting Data like below
Date1, Date2
01-02, 03-03
try this
releavedate - joindate+1 AS dtime
HI anil,
I am sending example data please find.
Thanking you,