News and Announcements icon

Power Platform CommunityForums Copilot Studio - General Formula to check if an...

Copilot Studio - General

Answered

Formula to check if an input date is within 48 hours

(1) Share

Report

Report

Posted on by JE-09091517-0

28

I am asking the user to input the date of their session using the prebuilt date entity and saving as a variable called Topic.session_date

I am then trying to create a metho din which I can check if session date is within 2 days of today's date.

I have tried creating a new variable called within_48 and used the following formula to output a true or false value but it failed:

Formula: =IF((TODAY() - Topic.session_date) <= 2, TRUE, FALSE)

I also tried using a condition of if Topic.session_date is Today() AND Today() - 1 AND Today() -2

but neither has worked.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

JE-09091517-0 28 on at

Like (2)

Report

Formula to check if an input date is within 48 hours

Figured it out, Posting here for anyone else who needs it!

If(

Abs(DateDiff(Today(), Topic.session_date, TimeUnit.Days)) <= 2,

True

False

)
Suggested answer

VinothSelvam 18 on at

Like (2)

Report

Formula to check if an input date is within 48 hours

Hello,

Can you try using the below expression.

If(
Abs(DateValue(Topic.Session_date) - Today()) <= 2,
"Date is within 2 days of today.",
"Date is not within 2 days of today."
)

Kindly update the variables accordingly.

Thanks.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 141,122

#2

RandyHayes 76,308

#3

Pstork1 63,414

Leaderboard

Featured topics

Generative orchestration updates coming to Microsoft Copilot Studio! 

Please Read for Updates on Forums & Blogs

Tips & tricks for using the Power Virtual Agents Boost Conversational Coverage Preview

Product updates

Microsoft Power Platform Community release plans