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).
formatting a decimal field as a date field
-
- 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:
- 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
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.
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.
-
- 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
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
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
- 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
Here is how I have the field defined in Visual Designer
Here is the formatted output when run
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.
Here is the formatted output when run
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.
-
- 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
it worked. I was using a different time format, as shown below.
- Attachments
-
- timeedt.docx
- (331.59 KiB) Downloaded 325 times
- 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
Glad it is working for you.
Who is online
Users browsing this forum: No registered users and 1 guest