Small and medium business | Business Central, N...

Job Queue Dispatcher: result of FORMAT function with DateTime value returns different time

(1) Share

Report

Posted on by Serdiuk

Good day,

We are using Business Central 14 on-prem, and I’ve encountered an unusual issue with the FORMAT function in the Job Queue Dispatcher. The formatted value of a DateTime variable differs by several hours from its original value.

Original DateTime value: 4:59 PM
Result value of FORMAT funciton: 10:29 PM

Discrepancy: 5.5 hours

Could you please advise if I might be overlooking an important parameter in the FORMAT function or any other potential cause for this discrepancy?

Thank you in advance for your help!

All responses (4)

Answers (0)

Suggested answer

Khushbu Rajvi. 4,744 on at

Like (3)

Report

Job Queue Dispatcher: result of FORMAT function with DateTime value returns different time

Yes if you want than you can raised Microsoft support request. here is the step by step explanation to raised ticket.

https://learn.microsoft.com/en-us/services-hub/unified/support/open-support-requests

https://community.dynamics.com/forums/thread/details/?threadid=94ff7107-6365-ef11-bfe2-7c1e5217aba5
Serdiuk 9 on at

Like (1)

Report

Job Queue Dispatcher: result of FORMAT function with DateTime value returns different time

Hi Khushbu,

Thank you for checking. Actually in some cases I receive correct values as well. I think this is somehow connected with the Job Queue Task Scheduler.

Do you know by a chance if I can report this issue directly to Microsoft and how to do it?
Suggested answer

Khushbu Rajvi. 4,744 on at

Like (2)

Report

Job Queue Dispatcher: result of FORMAT function with DateTime value returns different time

Suggestion: Set format for the datetime.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-format-property
Suggested answer

Khushbu Rajvi. 4,744 on at

Like (3)

Report

Job Queue Dispatcher: result of FORMAT function with DateTime value returns different time

Hi, I have run the same, and below is the output. I didn't see any discrepancies in the time.