Time formatting

[gt7301b]

I am reading in the help that I can format my date/time as either date or time. However, when I add a field as date/time it wants it to be a date in the webform. How can I reformat it to be a time. I don't see a formating option when I am in the table detail. Thanks in advance.

~michelle

Here is what it says in help:

Defines the time pattern. Choose one of the patterns available for the selected region, and provide your own AM and PM symbols if desired.

Applies to: Date/Time, Text

[bahar_vm]

Hi Michelle,

A database field can not store only time but store both date and time. However for display purposes you can set the formatting to only display the time portion.

Best,

Bahar M.

[AtayBalunbalunan]

For future reference, here's the documentation on how to format and display a field in a Report DataPage: https://howto.caspio.com/datapages/datapage-components/field-formatting-options/

[ParkLoey]

Hi there, it is also possible to get the time using calculations. You can find the sample and what code to use in this forum post:

 

[PotatoMato]

Hi! Just to add, you may check this link for different Date and time formats on SQL: https://www.sqlshack.com/sql-convert-date-functions-and-formats/