[mcundith]

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

[Loyal Water]

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

[mcundith]

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?

[mcundith]

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.

[Loyal Water]

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

[Author]

Posts