web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... The date formula shoul...

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

Suggested Answer

The date formula should a time unit...?

(1) Share

Report

Report

Posted on by MS-30040609-0

425

Hi,

When we try to send an email from a purchase order we get this error massage:

If I look at the lead time calculation it looks correct, even if I change language:

Has anyone else got this error massage? What might be wrong? And what can I do to fix it?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Saurav.Dhyani 14,414 User Group Leader on at

Like (1)

Report
Copy link

Link copied!
Hi,

I am not sure it's a localization or what.

The valid character that you can input in DateForumla is - D, WD, W, M Q or Y.

Where -

D - Days

W - Weeks

M - Month

Q - Quater

CW - Current Weeke

Reference - DateFormula Data Type - Business Central | Microsoft Learn

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,264 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, as Saurav mentioned, "V" letter is not allowed in the standard environment.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-date-ranges?wt.mc_id=DX-MVP-5004336#use-date-formulas

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,296 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I believe you don't need Lead Time Calculation when sending a standard purchase order email. Is this a customisation on the layout?

if yes, there could be an issue with the way the DateFormula is handled on the customisation.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,090 Super User 2026 Season 1

#1

OussamaSabbouh 2,090 Super User 2026 Season 1

#3

Dhiren Nagar 1,277 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans