[Last Call] Learn how to a build a cloud-first strategyRegister Now


Format Date in Crystal Enterprise Filename?

Posted on 2008-11-20
Medium Priority
Last Modified: 2012-05-05
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?
Question by:sizemorew
  • 2
LVL 17

Expert Comment

ID: 23005373
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....


Author Comment

ID: 23005961
I WISH it was SQL Server, but it's actually Impac.  It's a database for patient data.

Expert Comment

ID: 23191957
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")).


Accepted Solution

sizemorew earned 0 total points
ID: 23748320
I ended up creating a batch file for archival purposes which renames the file and adds the date.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Integration Management Part 2
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question