Keyword: Date & Time

#EN #Excel #Keyword

Updated over a week ago

Keyword to use

In order to display the date and/or time, you may use of the following keywords:

Description

Keyword to Use

Paperless Format

Date

date

January 1, 2021

Time

time

2:30PM (12h), 14:30 (24h)

Date & Time

datetime

January, 2021 2:30PM

With this control, you will be able to:

  • Access to a drop-down menu to change the date and/or time;

  • Tap on the N/A button to indicate your value in non applicable;

  • Tap on Today to get today's date and/or time;

  • Tape on Clear to empty the cell.


Type of controls available with this keyword

Field

Use the ABC method to create a field control.

Column

Use the 123 method to create a column control.


Validation rules available with this keyword

Did this answer your question?