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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Validation on a table

(0) ShareShare
ReportReport
Posted on by 700

Hi All,

pastedimage1568272770186v1.png

Above screenshot refers to the 'Entitlements Setup' page created.

In this page, a validation needs to be put i.e. if Year is same, then From Month should not be more than To Month. I tried some logics, but failed.

Could anyone please help me with the correct logic to achieve this ! Please provide AL Code.

Thanks!

Categories:
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Praveen,

    What are your datatypes? Is Month an Option field?

    Look at making both into a date field with DMY2DATE function and you can simply test that "to date" if bigger that "from date".

    docs.microsoft.com/.../dmy2date-function--date-

    Tero

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