How to get/find 10 min from time in business central.

(1) Share

Report

Posted on by Nil@@m

203

Hi Guys,
I want to give an styleexp on field which is based on condition:
Condition : I have one page.Call Distribution.On that page there is one field.i.e. Planned time
for example : planned time field has value is : 4:00:00 PM.
So before 10 minutes the planned time, for this field gets green color . means
If it is 10 min less than 4 o'clock,the colour of that field should be greeen
. and once passed the time it should turn red colour.
Is any way to do this.

Categories:

Dynamics 365 Business Central

All responses (10)

Answers (2)

Nil@@m 203 on at

Like (2)

Report

How to get/find 10 min from time in business central.

Hi @Khushbu Rajvi.

Thank you so much ,Yes i am already verify the answer.
Verified answer

Khushbu Rajvi. 4,744 on at

Like (3)

Report

How to get/find 10 min from time in business central.

The code defines a field for "Planned Time" with a style controlled dynamically by the StyleExprTxt variable. The OnAfterGetRecord trigger updates StyleExprTxt by calling the GetStyleBasedOnTime procedure from the TimeStyle codeunit. This procedure sets the field's style based on the current time and the planned time value:
It returns 'favorable' if the current time is within 10 minutes before the planned time.
It returns 'Unfavorable' if the current time is past the planned time.
It returns an empty string as a default if neither condition is met.

Don't forget to like and close it by verifying if answer is satisfied.
Verified answer

Nil@@m 203 on at

Like (1)

Report

How to get/find 10 min from time in business central.

Hi @Khushbu Rajvi.

Yes,this code its working Now. just for my clearness,can you please describe the code.so it will helpful for me.

Thank you for your guidance.
Suggested answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (2)

Report

How to get/find 10 min from time in business central.

Hi, In the latest version, you can use the following method directly.

Business Central 2024 wave 2 (BC25): New Date/Time/DateTime methods

https://yzhums.com/55408/

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 4,744 on at

Like (4)

Report

How to get/find 10 min from time in business central.

Hi, Code

Output: The system turns Planned time field green 10 minutes before time.

After it will turns into red.

Hope this will solve your issue.

Regards,
Khushbu Rajvi
Nil@@m 203 on at

Like (1)

Report

How to get/find 10 min from time in business central.

Hi @Yi Yong,

Do you have any record with an empty 'Planned Date' field? ->Yes
Suggested answer

Yi Yong 1,450 Super User 2024 Season 2 on at

Like (1)

Report

How to get/find 10 min from time in business central.

Hello,

Do you have any record with an empty 'Planned Date' field?

You might want to add a condition to make sure the calculation only takes place when both 'Planned Date' and 'Planned Time' are not blank.
Nil@@m 203 on at

Like (2)

Report

How to get/find 10 min from time in business central.

Hi @gdrenteria,@Khushbu Rajvi.

I know the knowlege behind the styleexp. i just want to know that 10 min condiction part.

like as per Yunzhu blogs,i have wriiten the same code but i am getting this type of error .my page is not opening
gdrenteria 12,290 Most Valuable Professional on at

Like (2)

Report

How to get/find 10 min from time in business central.

Hi

You can rely on the following to calculate.

Dynamics 365 Business Central: How to easily get Hour, Minute, or Second (HMS) from Time (Time Data Type) | Dynamics 365 Lab (yzhums.com)
Change field color based on field value in Dynamics 365 Business Central | Dynamics 365 Lab (yzhums.com)

Duration Data Type - Business Central | Microsoft Learn

Best

GR
Suggested answer

Khushbu Rajvi. 4,744 on at

Like (2)

Report

How to get/find 10 min from time in business central.

Yes, you can achieve this in Microsoft Dynamics 365 Business Central by using a combination of AL code for conditional styling and page extension customization.

For some hint: https://yzhums.com/1599/