• Learn
  • Blog
  • Pricing
  • About
  • Sign in

Understanding dates

Numbers can not only be formatted as fractions and percentages, but can also be formatted as dates and as times, which enables your users to enter such data. You can use date and time functions to manipulate the data entered by users and calculate new dates and times to show to your users.

Dates and times are represented as numbers and use the same format as popular spreadsheets. The integer part of the number represents the number of days that have elapsed since December 30, 1899, and the fractional part represents the time of day. The number 10.75 thus represents the 9th of January, 1900, at 6:00 pm (18:00). (0.75 means that three quarters of a day have elapsed.) Such numbers are known as sequential serial numbers.

As numbers, you can use numeric functions and numeric operators to manipulate sequential serial numbers. To calculate the number of days between two dates, simply subtract one sequential serial number from another. (Use the NETWORKDAYS function to calculate the number of whole working days between two dates.) To remove the time part from a sequential serial number, apply the FLOOR, TRUNC or INT function to the number. There are many helpful functions that deal with dates and times: use the reference sidebar to get an overview.

Format a number as a date by clicking the clock button in the inspector:

Formatting as date

Click the first drop-down menu to control how dates are formatted:

Formatting as date

Similarly, click the second drop-down menu to control how times are formatted:

Formatting as date

If the app language normally uses a 12-hour clock (which holds true for US English), click Force 24-hour clock to ensure that a 24-hour clock is used for that field.

A field can either display only a date, only a time or both.

When a date and time field is used for input, Calcapp Connect behaves differently depending on whether the user is running an iOS device (such as an iPhone or iPad), an Android device or something else entirely. For iOS and Android, Calcapp uses native date and time pickers, meaning that your users will get to use the date or time entry method they are used to.

iOS user interface

Here’s the user interface used on iOS. The first user interface is used when selecting only a date, the second when selecting only a time and the third when selecting both a date and a time:

Android user interface

Here’s the user interface used on Android:

Desktop user interface

If Calcapp Connect is not run on iOS or Android (such as when it’s running on a desktop computer), a different user interface is used:

So far, we have only covered numbers. Continue reading about logical fields, text fields and drop-down fields »