Date Formatting and locales

Hello,

I have a question which I hope has a simple answer ...

I have a report which contains dates from a web service data source eg 2011-06-29T00:00:00.000Z

When I display the data in the report it shows the date and time as 28-Jun-11 24:00 with a custom date mask of dd-MMM-yy kk:mm.

I would like the date to be displayed as 29-Jun-11 00:00.

What would I need to change to put midnight on the next day ?

I have tried a couple of locales but that doesn't seem to be the answer.

Thank you,
Andrew Park.

Find more posts tagged with

Comments

mwilliams

Try using HH in your format instead of kk. Let me know if that does it.

acpark

Thank you, that is what I was looking for ... also help once I got the server into the right timezone but that is a different story !

Cheers,
Andrew

mwilliams

Not a problem. Glad to help! Let us know whenever you have questions!