You’re offline. This is a read only version of the page.
32
Hi All,
I'm attempting to build an employee hub and the first thing I'm trying to do is a timesheet that will be sent through MS teams for approval.
Is there a way to build a dropdown for fortnightly end periods rather than weekly? if I use Today() then the weeks will change on when the user logs in.
I then want to get the dates to populate across the fortnight for the employee to imput their start/end/break.
any suggestions or videos anyone can recommend?
thank you
Simone
Hi @simone-stoller ,
You could set the combo box's items property to:
Share
Report
All responses (
Answers (
With(
{StardDate:DateAdd(Today(),1-Weekday(Today(),2) -If(Mod(WeekNum(Today()),2)=1,0,1)*7,Days)},
ForAll(
Sequence(14,0,1),
{Date:DateAdd(StardDate,Value,Days)}
)
)to get dates in two weeks.
Best Regards,
Bof
