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

(1) Share

Report

Posted on by Test user

289

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

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Khushbu Rajvi. 20,448 Super User 2025 Season 2 on at

Like (2)

Report

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/

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,234 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
Test user 289 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Suggested answer

Yi Yong 2,563 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Test user 289 on at

Like (1)

Report

Hi @Yi Yong,

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

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,448 Super User 2025 Season 2 on at

Like (4)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

Test user 289 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Khushbu Rajvi. 20,448 Super User 2025 Season 2 on at

Like (3)

Report

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.

Was this reply helpful? Yes No
Test user 289 on at

Like (2)

Report

Hi @Khushbu Rajvi.

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

Was this reply helpful? Yes No