Date Table,Calendar.FIND(SearchString)

Dynamics 365 Business Central/NAV Technical Forum
1

Hi friends,
recently I was going through FindDate function in Codeunit 359, PeriodFormManagement. Here got a line,
Found := Calendar.FIND(SearchString);
and value of SearchString is ‘=<>’ to find the record and I don’t know what does it mean. Do anyone know how to use this kind of value to find 1st day of current week?
Please help. Thanks in advance.

2

You can use CALCDATE function.

http://msdn.microsoft.com/en-us/library/dd301368.aspx

3

Calendar.FIND(’=<>’) means “find the record that exactly (=) matches the primary key-fields in Calendar”; if not found, then “find the nearest record, before (<), to primary key-fields in Calendar”; if not found, then “find the nearest record, after (>), to primary key-fields in Calendar”.

The first day of this week? “CALCDATE(’-CW’, TODAY);”

4

Always better to use <> in Dateexpession

“CALCDATE(’<-CW>’, TODAY);”

For example, if a user with language set to ENG (English) enters the date formula “1W+1D” for one week and one day, then a user with the language set to FRA (French) sees “1S+1J,” and a user with the language set to ESP (Spanish) sees “1S+1D”.

If a date formula is entered with < > delimiters surrounding it, then the date formula is stored in a generic, nonlanguage-dependent format. This makes it possible to develop date formulas that are not dependent on the currently selected language.

5

Correct :slight_smile:

6

Actually I too have the same doubt…

Thank you guys…