Open Forum

Expand all | Collapse all

Date formatting in BC Reports

  • 1.  Date formatting in BC Reports

    TOP CONTRIBUTOR
    Posted 29 days ago
    Hi All

    Working on a custom RDCL report in v13 on prem

    I've used SSRS a ton. Set text box properties for date on invoice to MM/DD/YY; however, it still displays as MonthName d, YYYY

    Anyone know how to change this, or why it doesn't use the formatting from the RDLC?

    Thanks

    Mark

    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Date formatting in BC Reports

    TOP CONTRIBUTOR
    Posted 29 days ago
    Short follow up. but not a solution.

    Found this: https://docs.microsoft.com/en-us/dynamics-nav/format-property

    But no option for mm/dd/yyyy

    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Date formatting in BC Reports

    TOP CONTRIBUTOR
    Posted 28 days ago
    Hi Mark,

    Try using <Month,2><Day,2><Year4>

    Meenakshi

    ------------------------------
    Meenakshi Singh
    Senior Manager, Business Applications
    Home Market Foods, Inc.
    NAVUG Programming Committee
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Date formatting in BC Reports

    TOP CONTRIBUTOR
    Posted 27 days ago
    Thanks Meenakshi

    will give it a try


    ------------------------------
    Mark Anderson
    Director of ERP Systems
    Clesen Wholesale
    Evanston, IL
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Date formatting in BC Reports

    TOP CONTRIBUTOR
    Posted 27 days ago
    Some reports do the date formatting in the code, before displaying it in the report.
    That means whatever you put as format on the field doesn't matter, as at that point it is already considered "Text".

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role