Hello
I have a Calendar as follows :
As you can see, If a user applies for leave for a SINGLE DAY from Calendar for FULL DAY, It shows Full Day in Brackets
For half day, It will display Session 1 (AM).
Now, If I want to apply in RANGE ( Aug 30-Aug 31 -- FULL DAY), It will show as :
Problem: If I apply in RANGE but I want to apply HAlf day for Aug 31... i.e., 1.5 Days
then it will display Session 1 (AM ) for both Aug 30 and Aug 31.
Fields: This is how I'm applying for a Leave
From Date -- From Session (Session 1/Session 2)
To Date -- To Session (Session 1/Session 2)
Session 1 = AM
Session 2 = PM
My Code :
If(ThisItem.FromSession="Session 1" && ThisItem.ToSession="Session 2" ,"Full Day",
ThisItem.FromSession="Session 1" && ThisItem.ToSession="Session 1" ,"Session 1",
ThisItem.FromSession="Session 2" && ThisItem.ToSession="Session 2","Session 2")
Required Output :
Aug 30 (Full Day) and Aug 31 (Session 1)
I hope my problem is understood.
But in your formula nowhere it is calculating based on the dates. It is only seeing the session dropdowns.
Therefore this formula (or any other) is always evaluating to Session 1 irrespective of what the dates are selected.
ThisItem.FromSession="Session 1" && ThisItem.ToSession="Session 1" ,"Session 1",
So need to work out on a logic to include dates too.
Yeah, I'm not able to figure that logic.
Can you help me in including dates along with sessions?
User | Count |
---|---|
253 | |
106 | |
94 | |
50 | |
39 |