facebook

Formating dates

  1. MyEclipse Archived
  2.  > 
  3. MyEclipse Reports
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #281481 Reply

    mcundith
    Member

    I have a data column in my data set that is an interger date in the format YYYYMMDD. How can I format it to MM/DD/YYYY? Thanks

    #281537 Reply

    Loyal Water
    Member

    You can right click on your field and go to Style > New Style > Format Date Times and select your formatting there.

    #281571 Reply

    mcundith
    Member

    I tried that and it doesn’t seem to work. It still prints in YYYYMMDD. I double checked and the data column is actually of type decimal not integer. Would this cause it not to format?

    #281575 Reply

    mcundith
    Member

    Ok i got it to work. I had to cast it to a char in the query string and then substring it out to the format that I wanted.

    #281602 Reply

    Loyal Water
    Member

    Glad you got it to work. Thanks for letting me know.

Viewing 5 posts - 1 through 5 (of 5 total)
Reply To: Formating dates

You must be logged in to post in the forum log in