Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all
here i am trying to get total days including weekend between fromdate and todate..
script
LOAD Id,
LeaveType,
OwnerName,
Date(CreatedDate,'DD/MM/YYYY') as LeaveDate,
Month(CreatedDate) as LeaveMont,
Year(CreatedDate) as LeaveYear,
Week(CreatedDate) as LeaveWeek,
From as fromdate,
To as todate
FROM
L_sheet.xlsx
(ooxml, embedded labels, table is Le25);
this is what i am trying
networkdays (Leaves.From,Leaves.To)
but here i get days without weekend..
when i do just
(Leaves.From - Leaves.To)
then i get this
whereas i want include weekend days also ..
how i do this
hi try this,
fabs(FLOOR(Interval(Date(Leaves.From,'DD-MMM-YYYY') - date(Leaves.To,'DD-MMM-YYYY'),'d')))
Instead of From - To, I guess you need To - From, i.e.
(Leaves.To - Leaves.From)
then this shows me only negative numbers.. nothing changed
@tresesco i mean nothing changed i still did not get whole date using this approch
leaves.to - leaves.from
@mahaveerbiraj still nothing changed .. still i did not get some data using this approch
If you use: =leaves.to - leaves.from
how does your output look like? Also let know your expected output.
Edit: In the meanwhile, you can try below as well:
=Interval(leaves.to - leaves.from, 'D')
@tresesco the output which i already posted in 2nd picture in question
Try to add two more expression in your chart, like:
=leaves.to - leaves.from
and
=Interval(leaves.to - leaves.from, 'D')
and share the output (screen shot) for them. Or, try to share your sample app.