JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Power Apps UDF Cooker
Introduction
About Author
UDF Functions
More
Share
Explore
Has Available
Formula Code
HasAvailable
(
selectedFrom
:
Date
,
selectedTo
:
Date
,
from
:
Date
,
to
:
Date
)
:
Boolean
=
Or
(
selectedFrom
>=
from
&&
selectedTo
<=
to
,
selectedFrom
<=
from
&&
selectedTo
<=
to
,
from
>
selectedFrom
&&
to
<
selectedTo
,
selectedFrom
>=
from
&&
selectedFrom
<=
to
)
;
Eye on Detail
Mostly, we play with Date functions in Power Apps. In this function we use
Or
function that helps you to combine all comparisons of selected date from/to with your default period, like between first and last day of a month.
Demo
Output
← Before Due Date
Working Days ->
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.