News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Job Queue Dispatcher: ...

Business Central forum

Unanswered

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

(1) Share

Report

Report

Posted on by CU11101649-0

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!

Categories:

Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 1,795 on at

Like (1)

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. 1,795 on at

Like (1)

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,645 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans