How do I write a formula for a text field that displays a Date field and a Time of Day field?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

Let's assume the Date field is called "My Date" and that the Time of Day field is called "My Time of Day". Let's also assume that you want the display format to be:

08-17-2001 01:01:01

Then the text formula to display the date and the timestamp fields together in one cell would be:

[My Date] & " " &

Right("0" & Hour([My Time of Day]), 2)

& ":" &

Right("0" & Minute([My Time of Day]), 2)

& ":" &

Right("0" & Second([My Time of Day]), 2)

Tags:

40234 reads

Comments

Time input format

Submitted by Bill Blackburn (not verified) on Thu, 04/05/2012 - 14:07.

How do I build a time input format / syntax in a form? I want the field to make it easy for the users to input times and AM/PM.

Time of Day

Submitted by sshearin on Fri, 04/06/2012 - 14:53.

Hi Bill --

There is a field type called Time of Day -- if you create a field with that type and add it to your form, people who use your app will be able to enter times in 12- or 24-hour format (for example: 3:40 p.m. or 15:40). Hope this helps,

Regards,

--Sybil

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Knowledge Base