• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1486
  • Last Modified:

Format Date in Crystal Enterprise Filename?

I'm trying to use Crystal Enterprise to pull data from a secured database, format it into a CSV file, and then FTP it to a server for a separate program to pick up and run with.  However, the filename needs to be in a certain format:

"Appointments DDMMYY.csv"

I know that to get a date in the filename, I'd need to use something like this:

"Appointments %SI_STARTTIME%.%EXT%"

However, the date isn't in the correct format.  Is there a way to custom format the date or is there an option I'm missing?
  • 2
1 Solution
MIKESoftware Solutions ConsultantCommented:
What backend are you using? SQL Server?

If so, I'd take this process "outside" of Crystal and use SQL Query and SQLCMD to handle the entire process....

sizemorewAuthor Commented:
I WISH it was SQL Server, but it's actually Impac.  It's a database for patient data.
I have also got the same problem in Business Objects XIR2.

I have tried using To_Text(Date(%SI_STARTTIME%,"yyyyMMdd")) to change the format of the variable,
the result I get is  To_Text(Date(2008-12-16-16-32-22,"yyyyMMdd")).

sizemorewAuthor Commented:
I ended up creating a batch file for archival purposes which renames the file and adds the date.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now