Positive Pay Report

SOLVED

Good morning, I have a positive pay report that currently shows a 2 digit year (i.e. 11/17/23).  How do I change it to show a 4 digit year (i.e. 11/17/2023) in Report Designer?

  • 0

    Double click the date field and it will open a list of formats to choose from.  

  • 0 in reply to Rhonda V

    When I double click the date field, I get a Field Format block that has Date (Design Formula) which shows the Length (10) Justification (Left, Center, Right) and Abbreviation (Abbreviate, Truncate).  I do not see a list of formats. 

  • 0 in reply to cesposito

    It's recognizing the result as alphanumeric format and not a date format based on the Design Formula.  I'm not aware of how to change this within a formula.   You could try to change that formula or omit that formula and just insert a check date field and then you could double-click the date field within the design and pick which date format you want.  Or my other suggestion would be to print the file to Excel and then open it with Excel and reformat inside Excel.  

  • 0
    SUGGESTED

    It's likely that your report is designed to output to a CSV or ASCII Text file for upload to your bank.

    Please open the report design in Report Designer, single-click to select the date field that you wish to change, and from the menu bar select Tools > Design Formula.  

    The formula window will display.  Please take a screen shot of the pop-up window that opens displaying the formula and post it in your reply to this message. I will try to help you decipher it and the changes that you need to make.

    Art Minds
    Senior Independent Consultant
    Pasadena, CA

  • +1 in reply to Rhonda V
    verified answer

    I just replaced it with a check date field and it worked.  Thanks so much for your help.

  • 0 in reply to cesposito
    SUGGESTED

    The formula is a JOIN formula which creates a TEXT output. As you can see from the formula, there are three other formulas that retrieve the month, day and year.  You would need to open the YEARS formula using the menu Tools > Formulas to understand how it was returning only the two digit year. You can post a screen capture of that formula if you would like further guidance.  

    Replacing the TEXT field of the date with a DATE formatted field may or may not work when the output is generated to deliver to your bank, depending on whether typical date formatting characters are included, i.e.  / or - between the month, day and year fields.  Often banks required only a string of digits without formatting characters, but if your bank accepts that then you're OK with the modification you made.

    Art Minds
    Senior Independent Consultant
    Pasadena, CA