How_do_I_add_date_time_or_counter_to_file_name_2024.08_

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 increment the counter value to show the next available number each time the file is saved. Here are a few examples of how Connect will format the date, time, and counter in a file name.  

 

Date and Time Variables

Anycity_Database_{DATE} {TIME}.zip

Anycity_Database_2021-11-18 093209.zip

 

Counter Variable

Anycity_Database_{COUNTER}.zip

Anycity_Database_0001.zip

Anycity_Database_0002.zip

Anycity_Database_0003.zip

 

Using variables in a file name will allow you to reuse a file name without typing in the date, time, or version every time you create the zip file. For example, City ABC uses Anycity_Database.zip as the file name for the Connect database zip file. Instead of renaming the zip file each time, City ABC inserts the date and time variable in the file name so the file name will format as  Anycity_Database_{DATE} {TIME}.zip. When City ABC runs the Send Database view, Connect will create a zip file that includes the date and time in the zip file name. 

Anyone who use Send Databases can insert the date, time, or counter variables into the zip file name. 

 

This view was updated in the 2024.08 release.

 

Adding variables to file name

1. Open Connect System Management > System Tools > Send Databases. 

2. Place the cursor in the file name at the location where you want to insert the variable. 

3. Click  at the end of the File Name box. 

 

File name menu 

 

Select the variables to insert into the file name. 

 

Variables list 

 

Example: C:\Users\SAW\Desktop\Temp\Anycity_{Counter}_{Date}_{Time}

 

{Date}

Insert YYYY-MM-DD. YYYY is a four-digit year. MM is a two-digit month. DD is a two-digit day. 

 

{Time}

Insert HHMMSS. H (hours), M (minutes), and S (seconds). 

 

{Counter}

Insert ####. Where each time the zip file is saved, the variable will use the next number in the file name. 

 

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • How do I insert the date, time, or count in a file name?

      When you create an export file, you can add a variable to the file name to insert the date, time, or count in the file name. Using the date, time, or count will ensure the file name is a unique file name and ensure the new export file does not ...
    • Warning: Export file name

      Issue I'm setting up a scheduled task to run a report and there's a warning message that says, "If there is not a file name stored for the definition then the task will not be processed." What does this mean? Export file name Explanation The ...
    • How do I add a date/time stamp to note entries?

      The date/time stamp will insert the current date and time into the body of the note. Connect can add the date/time stamp for you if you set up the default settings to always include the date/time stamp. Example: 03/17/2015 12:11 PM - JRR Adding a ...
    • Can I save a report as an Excel, PDF, RTF, or TXT file?

      Use Connect to save report data in a file that you can open in Excel, Adobe Reader, or any application that opens rich text or text files. Watch a video Learn how to save a report as an Excel, PDF, RTF, or TXT, attach a report to an email (5m38s). ...
    • How do I export a report as a delimited file?

      Use this option to create a file that can be used to send transmittal information to a third party program. Several options are available so you can set up the export options to create a file that will be easy to import. Exporting a report as ...