formatting a decimal field as a date field

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
chris_rover
Profound User
Posts: 88
Joined: Tue Jun 01, 2010 11:31 am
First Name: christopher
Last Name: williams
Company Name: banks dih limited
Phone: 592-226-9584
Address 1: thirst park
Address 2: ruimveldt
City: gerogetown
State / Province: Outside Canada/USA
Zip / Postal Code: 0000
Country: Guyana
Contact:

formatting a decimal field as a date field

Post 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).
User avatar
Brian
Profound Logic Staff Member
Posts: 286
Joined: Thu Apr 14, 2011 10:23 am
First Name: Brian
Last Name: May
Company Name: Profound Logic Software
Contact:

Re: formatting a decimal field as a date field

Post 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.
chris_rover
Profound User
Posts: 88
Joined: Tue Jun 01, 2010 11:31 am
First Name: christopher
Last Name: williams
Company Name: banks dih limited
Phone: 592-226-9584
Address 1: thirst park
Address 2: ruimveldt
City: gerogetown
State / Province: Outside Canada/USA
Zip / Postal Code: 0000
Country: Guyana
Contact:

Re: formatting a decimal field as a date field

Post 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
User avatar
Brian
Profound Logic Staff Member
Posts: 286
Joined: Thu Apr 14, 2011 10:23 am
First Name: Brian
Last Name: May
Company Name: Profound Logic Software
Contact:

Re: formatting a decimal field as a date field

Post by Brian »

Here is how I have the field defined in Visual Designer
Time_Decimal_Visual_Designer1.png
Time_Decimal_Visual_Designer1.png (148.61 KiB) Viewed 1903 times
Here is the formatted output when run
Time_Decimal_Run.png
Time_Decimal_Run.png (8.87 KiB) Viewed 1903 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.
chris_rover
Profound User
Posts: 88
Joined: Tue Jun 01, 2010 11:31 am
First Name: christopher
Last Name: williams
Company Name: banks dih limited
Phone: 592-226-9584
Address 1: thirst park
Address 2: ruimveldt
City: gerogetown
State / Province: Outside Canada/USA
Zip / Postal Code: 0000
Country: Guyana
Contact:

Re: formatting a decimal field as a date field

Post by chris_rover »

it worked. I was using a different time format, as shown below.
Attachments
timeedt.docx
(331.59 KiB) Downloaded 325 times
User avatar
Brian
Profound Logic Staff Member
Posts: 286
Joined: Thu Apr 14, 2011 10:23 am
First Name: Brian
Last Name: May
Company Name: Profound Logic Software
Contact:

Re: formatting a decimal field as a date field

Post by Brian »

Glad it is working for you.
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests