Date field not printing to PDF with correct OutputFormat

Forum Forums D-Tools General Forum Bugs Date field not printing to PDF with correct OutputFormat

This topic contains 3 replies, has 3 voices, and was last updated by  Narayana Karthik 2 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #12925 Reply

    bertles86
    Participant

    I have a custom report, which uses one of the available Product/Labor Custom Fields (Custom Field 11), which has a Data Type of “Date”.

    In the Standard Report Designer, I have added that field to the report from the ReportExplorer.

    I have then set the OutputFormat to “DD-MMM-YYYY”, hoping to get an output in the report of (for example): 01-Sep-2017.

    The problem is, the report does not adhere to the OutputFormat, and just outputs “MM-DD-YYYY” which is the American format. It ignores any formatting conditions completely, as I have tried different types like “DD-MM-YY” and “DD-MM-YYYY” and it doesn’t work.

    Nor does D-Tools recognise the OutputFormat “d” which should pull the date format from my operating system. But it still just outputs the American format, as my OS is set to “DD-MMM-YYYY”.

    Does anyone have any ideas how to resolve this big?

    #12926 Reply

    Narayana Karthik

    Hi,
    To get output “01-Sep-2017” please try this “dd-MMM-yyyy” format, set OutputFormat property of textbox to dd-MMM-yyyy

    Hope it helps.

    #12927 Reply

    bertles86
    Participant

    @Narayana – thanks for the reply. I have just tried the format you suggested and the report output remains the same: mm-dd-yyyy.

    Any more ideas? :)

    #12928 Reply

    Narayana Karthik
    Participant

    Hi,
    I have just now checked with that format, it works perfectly, please check the below links –
    1. Custom report with custom field11 (whose output format set to ‘dd-MMM-yyyy’)
    http://downloads.d-tools.com/si/forum/rpt1.png

    2. Project Item with custom field 11 value set –
    http://downloads.d-tools.com/si/forum/rpt2.png

    3. Custom report renders the format correctly –
    http://downloads.d-tools.com/si/forum/rpt3.png

    Please check your changes.
    If you still face the same issue again please contact support with your custom report.

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Date field not printing to PDF with correct OutputFormat
Your information:





<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre> <em> <strong> <del datetime=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">