Page 1 of 1
formatting a decimal field as a date field
Posted: Wed May 25, 2011 5:34 pm
by chris_rover
Hi,
I have a decimal field on a display that i am trying to get to show with time formatting. is there any way this can be done?
also, when i selected the "time" as the format, and I enter a figure, it changes it to only accept the last 4 figures(I am using a 6 digit field to hold hour, mins, and seconds).
Re: formatting a decimal field as a date field
Posted: Wed May 25, 2011 6:36 pm
by Brian
In the Visual Designer, double click the field in question. You should be taken to the binding window.
In this window you should be able to select Time in the "Field Formatting" list and then scroll down in the "Time Format" list until you find the format you need.
Re: formatting a decimal field as a date field
Posted: Fri May 27, 2011 8:59 am
by chris_rover
Hi ,
that's what I've been doing. I have yet to get that displayed with any sort of time formatting. maybe I am doing something wrong. the user guide doesn't state anything about data formatting
Re: formatting a decimal field as a date field
Posted: Fri May 27, 2011 10:02 am
by Brian
Here is how I have the field defined in Visual Designer
- Time_Decimal_Visual_Designer1.png (148.61 KiB) Viewed 1901 times
Here is the formatted output when run
- Time_Decimal_Run.png (8.87 KiB) Viewed 1901 times
I could enter as many digits as I wanted. However, the run time will show a validation error unless the time is formatted as specified. So in my example, the colons must be included.
Re: formatting a decimal field as a date field
Posted: Fri May 27, 2011 11:40 am
by chris_rover
it worked. I was using a different time format, as shown below.
Re: formatting a decimal field as a date field
Posted: Fri May 27, 2011 11:44 am
by Brian
Glad it is working for you.