Format Date in Crystal Enterprise Filename?

Posted on 2008-11-20
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
    LVL 17

    Expert Comment

    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

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

    Expert Comment

    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

    I ended up creating a batch file for archival purposes which renames the file and adds the date.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now