Hello TGElkland,
You can reference the post below when working with different types of database projects. The FORMATTING TIME AND DATE DATA section goes over ways to set the clock to a desired style.
http://www.noventri.com/forum/viewtopic.php?f=61&t=225
Working with Database Time/Date fields:
We have an option in Noventri Suite to select multiple time formats or even create your own, this way the original data can be preserved in the data source. Once the date is properly pulled from the database and shows up in Suite, select the Text tab in the properties panel and click the Time Format drop-down. You will have a few preset data formats to choose from. If you cannot find a format you would like to use, select the closest one, then click the drop-down again, and select Custom this time. A new text-box will appear near the Time Format drop-down to allow you to customize the output anyway you like.
Take a look at the pages
here and
here to see a list of time formatters that can be used in the custom text-box.
Removing the 0's after whole numbers:
Once the date is properly pulled from the database and shows up in Suite, select the Advanced tab in the properties panel and click the Select button to bring up the Select Table dialog. Click the Advanced radio button in the top Database section to enable the Select Statement text-box. This will allow you to type custom select statement and add additional formatting to your data before the it gets pushed to the screen.
Examples:
This will display all fields in the table "Events".
The example below will remove any 0's at the end of whole
numbers while leaving decimals when they need to be there.
Code: Select all
SELECT *, cStr(TotalCost) AS RemovedDecimalFrom_TotalCost FROM [Events$]
Once the select statement has been modified, click the green Refresh button to the right to see the results. A new column will be added to the table called "RemovedDecimalFrom_TotalCost" (from the example above) that list the converted numbers and leave the "TotalCost" column with the original data. At this point, just use the new formatter to output the data to the screen.
If you have any further questions or need any assistance, please let me know.
Kind Regards,
Sergey