Date Filter Should accecpt only Starting & Ending Dates of a Month

Business Central/NAV Developers Forum
1

Hi all,

I want to keep a validation in specified report in such a way that "in starting date field it should accept only starting date of a month and in ending date field should accept only ending date of a month. Please help me doing this.

Thank U

2

What did you try till now?

3

Hi Mohana,

CALCDATE(’<-CM-1M>’, StartDate). So StartDate that starts with ‘01’ but in case of end date it should be of ‘30’ OR ‘31’. How i can give condition here.

Thank U

4

InputDate := 310510D; IF InputDate <> CALCDATE(’’,InputDate) THEN Error(‘Input Date is not Ending Date of Month.’);

5

It should be like this

InputDate := 310510D; IF InputDate <> CALCDATE(‘CM’,InputDate) THEN Error(‘Input Date is not Ending Date of Month.’);