web

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

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Date Formula

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

Suggested Answer

Date Formula

(0) Share

Report

Report

Posted on by adityamohite

79

I tried using Dateformula as a data type for a field, and I found out that it does not accept standard Date. Can anyone suggest something

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

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

Like (0)

Report
Copy link

Link copied!

The DateFormula is not a date. It is a formula to calculate the date, such as 1D (1 day) or 1W (1week).

Read more here.

docs.microsoft.com/.../devenv-dateformula-property

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,419 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

For saving date values use Date or DateTime Field.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 2,334 Super User 2026 Season 1

#2

YUN ZHU 1,717 Super User 2026 Season 1

#3

AndrewThomas81 1,470

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans