Incorrect Format of Time Data Type on Page

Johannes_Nielsen

Hi all

Using 7.0.34194.0

On a Worksheet Page in a Repeater.

It seems time is displayed as TT:MM:SSS,mmm

with mmm=mili seconds.

Even when my regional settings in Windows States TT:MM:SS (Danish)

If I change to date format in Regional Setting, this affects the Date format in NAV fine.
It's just the time format which does'nt behave.

Is this a bug?

I've tried DecimalPlaces property, but this have no effect on the format either.

alex9

I have the same question. Does anybody know any answer?

alex9

OK, I found an answer. It should be FORMAT(Rec.MyTime) instead of just Rec.MyTime in the source expression of the field on the page.
It seems to me, this was not required on pages in NAV 2009.

Johannes_Nielsen

alex9 wrote:

OK, I found an answer. It should be FORMAT(Rec.MyTime) instead of just Rec.MyTime in the source expression of the field on the page.
It seems to me, this was not required on pages in NAV 2009.

Hi
Thanks for sharing.

Sure we can format every time value but my concerns are:

- I havn't been able to find any documentation of this change. Was it intentional? 8)

- I don't want to make a number of modifications in ISV products if this is a bug

alex9

Those decimals appears if time field is populated with TIME function. If user enters time manually, then there are no decimals. In standard NAV they do not have many fields auto populated with TIME function. May be, that is why this bug has not been noticed by MS.

Johannes_Nielsen

Thanks for sharing

I've entered the issue on MS Connect to notify MS of the issue.