How_do_I_format_a_date_

How do I format a date?

Connect will use the default format to print the values in a column. You can replace the default format with the format that best suits the purpose of the report.

Here's a list of available date formats:

Format

Output

MM/DD/YYYY

07/27/2015

DDD, Mmmm DD, YYYY

Mon, July 27, 2015

Mmmm DD, YYYY

July 27, 2015

MM/DD

07/27

YYYY-MM-DD

2015-07-27

MM.DD.YY

07.27.15

MMM. DD, YY

Jul. 27, 15

DD Mmmm, YYYY

27 July, 2015

Mmmm, DD

July, 15

MMM-DD

Jul-15

MM/DD/YY H:mm tt

07/27/15 16:02 PM

MM/DD/YY H:mm:ss tt

07/27/16 16:02:37 PM

H:mm tt

16:02 PM

H:mm:ss tt

16:02:37 PM

H:,,

16:02


Here's a list of available date formats:

07/27/2015

Mon, July 27, 2015

July 27, 2015

07/27

2015-07-27

07.27.15

Jul. 27, 15

27 July, 2015

July, 15

Jul-15

07/27/15 16:02 PM

07/27/16 16:02:37 PM

16:02 PM

16:02:37 PM

16:02


Formatting a date

1. Open a report.

2. Click to select the Columns tab.

3. Use the Section menu to select the report section that will contain the new report line.

4. Click to select a column that displays a date.

The column properties display on the Column subtab.

5. Find the section titled Format.

6. Click to select the option titled Custom.

7. Click to select the button at the end of the Custom field.

 

Custom Format button

 

The Date Format form displays.

 

Date Format form

 

8. Click to select a date format from the list.

 

Date Format form

 

9. Click OK.

Connect will use the selected format to display the dates in the column.

 

Displays the new custom date format

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.


    • Related Articles

    • Import Checks - Check issue date

      Enter the check issue date. The system will use this date to record the check. The check issue date is the official date the check is considered issued or created. This date is a critical field in the import file and typically represents the date ...

    • How do I add an electronic reading format?

      Some meters can transmit meter readings from a meter at a service location to the meter reader. If your organization is using electronic meter reading, you will need to set up an electronic reading format to format the the meter reading file from the ...

    • How do I set up a report date to select the 15th or 30th?

      Set up the electronic file format for a state retirement report to print the report for the date range ending in MM/15, MM/30, or MM/31 even though checks for the pay period were processed on a different date. This option is available in the state ...

    • How do I add date, time, or counter to file name? (2024.08)

      Save a database as a zip file. When you format the file name, you can add a variable to insert the date, time, or counter. Adding the date or time will save the date and time when the zip file was created. Inserting a counter will automatically ...

    • How do I change default formats for amount, date, number, and yes/no?

      Reports and forms use characters and symbols to show how information for amounts, dates, numbers, and yes/no checkboxes will be printed. You can use the default format or you can replace the default format with a custom format. The number of ...