Is there a way to get rid of the seconds in a Date-Time field value? For example Apr 02,2010 23:01:38 should be displayed as Apr 02,2010 23:01

Is there a way to get rid of the seconds in a Date-Time field value? For example Apr 02,2010 23:01:38 should be displayed as Apr 02,2010 23:01

You'll need to create a formula field in your form with a formula expression as below to truncate the value starting from the last ':' and display the resultant value in your view/form in that formula field.

(Datefield.toString()).subString(0,((Datefield.toString())).lastIndexOf(":")) 

,where Datefield is the deluge name of the date-time field on the form.

Note: It would not be possible to remove the seconds component altogether from live display on a date-time field as its a default component which cannot be customised.

    • Related Articles

    • Date-field Autoresponder

      Understanding date-field autoresponder Date-field based autoresponders are a series of automated messages that are sent to contacts based on the date in the date field associated with them. Wishing customers happy birthdays and anniversaries are ...

    • How do I get the date and time and input it into a field upon success?

      Every record in every table (form) has two fields (Added Time and Last Modified Time) that ZOHO Creator automatically updates when ever a Form is clicked on the Submit or Update Buttons, so you could elect to show these fields in your List ...

    • How can I add days to a date field?

      You can manipulate a date field by using the + (to add) and - (to subtract) Operators or by using the Built-in date functions. For example, if you would like to add 364 days to a particular date field, say StartDate and display it in another field, ...

    • Time-based Workflows

      This Workflow triggers at the time you specify, either once or recurring. User scenario One-time workflow Jane sends promotional campaigns to all workflows in her mailing list. She wants to give special offers to her active contacts. To decide who ...

    • Time-based workflow

      This workflow triggers at the time you specify, either once or recurrently. User scenario One-time workflow Jane sends promotional email campaigns to all leads in her mailing list. She wants to give special offers to her active leads. To decide who ...