Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Time field format on pages

Posted on by 1,645

Hello,

Is there any way to change the default time format (4:00:50.193 PM) to Hours, Minutes, Seconds instead (4:00:50 PM)?

I know there is a way using FORMAT() but then, the value type will change to text instead of time.

Thank you in advance.

*This post is locked for comments

  • spyroot Profile Picture
    spyroot 1,645 on at
    RE: Time field format on pages

    Thank you to all.

  • Verified answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Time field format on pages

    Hi Alex,

    You cannot archive it with standard property. Some useful properties are removed from NAV 2013 such as "Font Name", "Font Size", "ForeColor", ... including "Format" that can solve your problem.

    It is pity that you should use FORMAT function and convert it to text :-(

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Time field format on pages

    I do not think there is a function available to do this. As MMV said you can use the text format and since this is just to display the details, it won't be a matter much.

  • Verified answer
    mmv Profile Picture
    mmv 11,465 on at
    RE: Time field format on pages

    Hi,

    I don't think there is any property which allows you to have that format without using the FORMAT function.

    Best Regards,

    MMV

  • spyroot Profile Picture
    spyroot 1,645 on at
    RE: Time field format on pages

    There is not issue at all. Just wondering if there is any hidden property I can use. One example is DecimalPlaces property allows to assign number of decimals if wanted.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Time field format on pages

    Hi,

    On the Page, even if the time is changed to text format, is there any issue?

    Best Regards,

    MMV

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans