How Check if a date is in next 14 days?

Hi anushas0002 ,
If I get you understood your question correctly, using below expression in "validation" attribute of date field may help

if(today()+14 >= ri!date, null, "Error")

Which functions are not sufficient?

Hi Anusha,
Please try below code ....

a!dateField(
value: ri!date,
saveInto: ri!date,
validations: if(ri!date+14>=ri!date,"True message","False Message")
)

There is no date comparision function that can handle string type of date too, instead of having to convert to datetime.

Hi,

I think below code may be helpful

caladddays(now(), 14)

tried this but not working as expected the comparision and there is no option to debug the code and it isn't throwing any error either. It isn't returning expected value based on that condition.

Hi Anusha,
This might be helpful:
if(ri!date+14>=ri!date,"True message","False Message")

Hi Anusha,

Simply add 14 days to today's date and check with if respective date is greater than or equals to date

today() + 14 >= ri!date_dt

Hi,

How to check if a list of dates has any date <= today() + 14? The above condition works for single date. But without using foreach how to find count of all dates that are <= today()+14 in a list of dates? Sample code being used is below

with(
local!events: rule!GetAllEventsExpressionRule(),
local!statusList: rule!GetStatusList().result.body,
local!etbc_array: {},
a!forEach(
items: index(
index(
local!events.data,
"RequestedDate",
{}
),
wherecontains(
displayvalue(
"Pending",
index(
local!statusList,
"Status",
{}
),
index(
local!statusList,
"Id",
{}
),
{}
),
index(
local!events.data,
"Status",
{}
)
),
{}
),
expression: if(
todate(
todatetime(
fv!item
)
) > todate(
caladddays(
today(),
14
)
),
if(count(fv!item) > 0, fv!item, null),
{}
)
)
)

Tried to use foreach which works fine in positive scenario, but in negative scenario it's returning 0 in list of variants due to which when i try length(dates from list of dates that are <= today() + 14) as shown below. which means irrespective of condition check always the foreach count is being returned instead of count of values that passed the condition in a list.

List of Variant: 2 items
List of Variant: 0 items
List of Variant: 0 items

Hi Anusha,

Its not very clear why you cannot use foreach, but, if you want to fetch all the dates which are < = 14 days from the list of dates, can you try below code:

with(
/* If you want index of dates qualified. index can be useful to retrieve related data from complex or custom data type.
Use wherecontains function.
*/
local!qulifiedDateIndex: a!forEach(
items: ri!dateList,
expression: if(
fv!item <= (today() + 14),
fv!index,
null
)
),
/* If you want dates qualified*/
local!qulifiedDates: a!forEach(
items: ri!dateList,
expression: if(
fv!item <= (today() + 14),
fv!item,
null
)
),
reject(fn!isnull, local!qulifiedDates)
)

Thanks.