Skip to Content
avatar image
Former Member

How do I change an excel file filename to only have HH:mm (not seconds)

Hi,

I hope someone can help. I need to produce Excel sheets of a Crystal report - this is fine, the report has been created and is currently being sent to a shared location but the filename seems to have limited options for creating filenames, i.e. datetime which results in the following format FILENAME & DATE & HH:mm:ss. I don't want the ss part of the date to appear.

Any ideas?

TIA

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 15 at 08:45 AM

    Hi Marcia

    If you are using CMC you are stuck with the HH:mm:ss format.

    I had same problem and had to get someone to create a batch file which trimmed off the :ss from the name and move file to another folder. No longer at that company so can't share code, apparently it is quite easy if you know how:-)

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 13 at 04:43 PM

    Hi Marcia,

    When exporting to Excel from CR designer it does not append the date/time into the file name, you specify the name to save as.

    Are you using an application to do the exporting? Possibly scheduling from BOE?

    Don

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14 at 01:16 PM

    Hi Don,

    Thanks for your reply. I am using the CMC to schedule the report to be saved to an "unmanaged" disk. The name of the file that is saved on the unmanaged disk should only have a time (HH:mm) and not add the seconds at the end.

    Thanks,

    Marcia

    Add comment
    10|10000 characters needed characters exceeded