web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Business Central forum

Invalid value in Posting Date

(0) ShareShare
ReportReport
Posted on by

Hey guys,

I have created a field for the posting date and it is filled automatically by the current workdate.

If I want to change the posting date, it is only possible, if i give date in like this: dd.mm.yyyy

pastedimage1568279746371v3.png

But if I choose the calendar next to the field and choose a date, the field is filled in that way: mm/dd/yyyy and shows me then some error message:

pastedimage1568279762244v5.png

"The input is not a valid value for Posting Date. The value cannot be evaluated in type Date".

How to solve this? Is it an issue in my settings or do I have to use the Format function in the OnValidate-trigger of my field?

Thank you :)

Categories:
I have the same question (0)
  • Bjorn Enbom Profile Picture
    25 on at

    Hi, I have the same issue, and all my region settings are set (In this case to swedish, where date format is yyyy-mm-dd). When I select a day from the calendar (anywhere where I got the option to do so) it is written d/m/yyyy and because that is not the right format I get an error message.

    I've run out of ideas and help would be much appreciated.

  • Bjorn Enbom Profile Picture
    25 on at

    Hi,

    Did you manage to solve this? I'm experiencing the same issue.

  • Community Member Profile Picture
    on at

    The region I have chosen is Germany and if I open the card the right date value is selected. But after using the calendar I get the slashes and then it is not possible for me to leave the field without the error message...

    Now I tried to change the workdate in the settings with the calendar to choose another date and there I get the same error message, because it also changes from 01.01.2021 to 01/01/2021...

    Think it is a bug?!

  • Suggested answer
    Avinash B Profile Picture
    1,455 on at

    Hi

    The date format is always based on the region what you have selected. Please check the date format of the selected region.

    Regards

    Avinash B

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans