Options

Set Default Time Format

StLiStLi Member Posts: 83
edited 2014-12-03 in NAV Three Tier
Hi!

I'm using a lot of Time-Fields lately which are filled with the TIME() function. Meaning they get their values set precisely down to the millisecond. (which is fine) But i don't want to show these Milliseconds to the user on the Pages for aestetic reasons. (the local settings interpretation of navision does that.)

So i usually have to set the format on every field in every page with FORMAT("My Time Field",0,'<Hours24,2>:<Minutes,2>:<Seconds,2>')
to get from stuff like this: "09:30:53.463" to this: "09:30:53"

I was wondering if there is any way to overwrite the default timeformat so i don't have to look for every time-field in our solution to replace it with the formatted one.

A nice bonus would be if i could still use the format in the source expression whenever i want a different format (didn't happen yet, but might become necessary.)

best regards and thank you in advance.

Comments

  • Options
    Rishi1109Rishi1109 Member Posts: 43
    Have you tried by changing regional setting of server ??
    Thanks and Regards
    Rishi
  • Options
    StLiStLi Member Posts: 83
    Eh changing the gional settings didn't help and woudn't be an option for the customer eighter. I gave up and rounded everything as described above -.-
Sign In or Register to comment.