.NET Crystal Reports: date field format

Posted on 2009-04-18
Last Modified: 2012-05-06
I'm using 2.0: I've created a local Crystal Report and one of the fields is a date that's showing the date and time. I'm just want the date to show like mm/dd/yyyy.
Question by:techpr0
    LVL 7

    Expert Comment

    enter in the dataformat property of the field:  {0:mm/dd/yyyy}  
    LVL 33

    Expert Comment

    If this date is comming from a database field, on the Properties of that object, change the DateOrder propertie to crMonthDayYear.

    LVL 100

    Accepted Solution

    You can simply format the datetime field to show only the date.
    Right click the field
    Select the DATE format you want

    Another way would to use a formula on the report
    Create a new formula


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now