Date Filter : Limit Totals

jhanvincent14 · 2018-10-12

Hello, Good day.

is there any possibilities we can code this is C/SIDE? thanks

Slawek_Guzek · 2018-10-12

SETRANGE("Date Filter", FromDate, ToDate)
SETFILTER("Date Filter", Filter Expression);

The limits total shows up when you have a field (a Date Filter in this case) of the type FlowFilter in the table.
Your particular filter would look like this:

SETRANGE("Date Filter", 0d, 101218D);

or

SETFILTER("Date Filter", '..%1', 101218D);--date in English UK format

kriki · 2018-10-12

Stop using 12102018D. but use DMY2DATE(12,10,2018); During an upgrade project, I noticed MS changing something in this way.

Slawek_Guzek · 2018-10-12

SETRANGE("Date Filter", FromDate, ToDate)
SETFILTER("Date Filter", Filter Expression);

The limits total shows up when you have a field (a Date Filter in this case) of the type FlowFilter in the table.
Your particular filter would look like this:

SETRANGE("Date Filter", 0d, 101218D);

or

SETFILTER("Date Filter", '..%1', 101218D);--date in English UK format

kriki · 2018-10-12

Stop using 12102018D. but use DMY2DATE(12,10,2018); During an upgrade project, I noticed MS changing something in this way.

Slawek_Guzek · 2018-10-13

I don't think that using constants like 12102018D is that harmful. It could be though if you trying to merge code exported from your database and an object text source obtained from elsewhere, where locale setting could differ, But if all objects to be merged are exported to text on the same PC date constant will be exported in the same text representations.

I guess Microsoft started using DMY2DATE as their code is supposed to be merged to apps in different countries, hence the problem, and the change in the standard code to avoid it.

kriki · 2018-10-15

And my gut feeling is that sooner or later they will break 12102018D.....

jhanvincent14 · 2018-10-17

Slawek_Guzek wrote: »
SETRANGE("Date Filter", FromDate, ToDate)
SETFILTER("Date Filter", Filter Expression);
The limits total shows up when you have a field (a Date Filter in this case) of the type FlowFilter in the table.
Your particular filter would look like this:
SETRANGE("Date Filter", 0d, 101218D);
or
SETFILTER("Date Filter", '..%1', 101218D);--date in English UK format

@Slawek_Guzek thank you so much. great help

this solves my problem

jhanvincent14 · 2018-10-17

kriki wrote: »

Stop using 12102018D. but use DMY2DATE(12,10,2018); During an upgrade project, I noticed MS changing something in this way.

@kriki thanks. I will take note this one

Date Filter : Limit Totals

Best Answers

Answers

Categories