Calculated Fields Formula Help

(0) Share

Report

Posted on by JH-10042124-0

I am trying to calculate the days left in a trial from a specific end date. I feel like I have tried every variation of formula.

These are the fields that I am working with:

Start Date (DateTime)

End Date (Calculated - IF Start Date contains data ACTION Set End Date to AddDays(30, Start Date))

Days Left (Calculated - ??? This is where I am stuck. I need the solution to be a number)

Any help would be so appreciated!

Categories:

Building Power Apps

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,052 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JH-10042124-0,

Assuming the control you are using is in a Form or a Gallery (hence the ThisItem reference) and you are after the end date

If( Value(ThisItem.'Start Date') > 1, ThisItem.'Start Date' + 30 )

If you are looking for the days left from the current day to the end date

If( Value(ThisItem.'Start Date') > 1, DateDiff( Today(), ThisItem.'Start Date' + 30, TimeUnit.Days ) )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
JH-10042124-0 2 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I am limited to this Calculated Field window.

Was this reply helpful? Yes No
Vish WR 1,102 on at

Like (0)

Report
Copy link

Link copied!

Can you try using this approach and see if it works:

DATEDIFF(NOW(), ADDDAYS('First Call Date', 30), DAY)

This should calculate the days between today and your trial end date and return it as a whole number. Let me know if that does the trick!

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
WarrenBelz 155,052 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JH-10042124-0,

I was assuming you were referring to a Power Apps field (this is a Power Apps forum). For a Dynamics 365 calculated field, it would be something like
DIFFINDAYS(End Date, NOW())

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,052 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @JH-10042124-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No