Date Handling

Appizy is capable of handling date inputs. Similar to Excel, you can utilize most date-related functions and perform arithmetic operations such as =DATE+2 (which adds 2 days to your DATE input) or =IF(DATE_1 < DATE_2, …, …) to conditionally change results based on date comparisons. This is possible because dates are treated as plain numbers in the background.

Clear Date Input in Initial Application State

For Appizy to recognize a cell as a date, you need to enter a default value. This is akin to number inputs, which also require a default value (see our article on this topic here). For number inputs, we recommend setting the default value to 0 and using the “Clear zero inputs” option to reset the input in the initial state of the application. For date inputs, we have determined that the zero date is January 1, 2000. This is how we achieve an empty field in the form below.

To detect errors or user inputs, you may want to add conditions such as =DATE>0 to check if a date input is set, or =DATE>TODAY() to verify if a date is filled and greater than today. This is how we display error messages in our reservation form.

Time Limitations

Appizy does not support date-time or time inputs. If you attempt to use a date-time input, Appizy will issue a warning during the conversion process, and the input will be simplified to a date input only. Additionally, the function =NOW() is not supported; however, you can use =TODAY(), which is equivalent but does not include the time dimension.

That said, there are some workarounds for this limitation. The educational tool below allows students to manipulate speed and distance in relation to time. The time input is divided into two dropdown selectors. Given the time and distance, the duration is calculated as a decimal value and then converted back to a time display in hours and minutes.

Timezone

The web version of your tools is not intended to be timezone-sensitive. It should adapt to the local timezone of the end user. Nevertheless, we encourage you to carefully check the output and report any anomalies you may encounter.