web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Suggested answer
    Avinash B Profile Picture
    1,455 on at
    RE: Invalid value in Posting Date

    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

  • Community Member Profile Picture
    on at
    RE: Invalid value in Posting Date

    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?!

  • Bjorn Enbom Profile Picture
    25 on at
    RE: Invalid value in Posting Date

    Hi,

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

  • Bjorn Enbom Profile Picture
    25 on at
    RE: Invalid value in Posting Date

    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.

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

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