Date Filter : Limit Totals

jhanvincent14jhanvincent14 Member Posts: 214
Hello, Good day.

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

dorne39tlwo8.png

Best Answers

Answers

  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    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.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • krikikriki Member, Moderator Posts: 9,094
    And my gut feeling is that sooner or later they will break 12102018D.....
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • jhanvincent14jhanvincent14 Member Posts: 214
    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 :)
  • jhanvincent14jhanvincent14 Member Posts: 214
    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 :)
Sign In or Register to comment.