Question Status

Verified
Alex asked a question on 20 Feb 2015 3:36 PM

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.

Reply
mmv responded on 24 Feb 2015 3:53 AM

Hi,

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

Best Regards,

MMV

Reply
Alex responded on 24 Feb 2015 12:19 PM

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.

Reply
Verified Answer
mmv responded on 24 Feb 2015 9:45 PM

Hi,

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

Best Regards,

MMV

Reply
Verified Answer
Tharanga Chandrasekara responded on 24 Feb 2015 10:34 PM

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.

----------------------------------

Best regards,

Tharanga Chandrasekara.
For more info :  NAV Community Blog NAV Blogspot

Please verify the answer if it satisfy your question.

Reply
Verified Answer
Khoa Nguyen responded on 25 Feb 2015 4:23 AM

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 :-(

----------------------------------------------------------------------
Thanks and best regards,
Khoa Nguyen (Mr.) | Director
Email: khoa@4bzsoftware.com
www.4bzsoftware.com

Reply
Alex responded on 25 Feb 2015 3:27 PM

Thank you to all.

Reply
Verified Answer
mmv responded on 24 Feb 2015 9:45 PM

Hi,

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

Best Regards,

MMV

Reply
Verified Answer
Tharanga Chandrasekara responded on 24 Feb 2015 10:34 PM

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.

----------------------------------

Best regards,

Tharanga Chandrasekara.
For more info :  NAV Community Blog NAV Blogspot

Please verify the answer if it satisfy your question.

Reply
Verified Answer
Khoa Nguyen responded on 25 Feb 2015 4:23 AM

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 :-(

----------------------------------------------------------------------
Thanks and best regards,
Khoa Nguyen (Mr.) | Director
Email: khoa@4bzsoftware.com
www.4bzsoftware.com

Reply