We would love to hear from you on how we can improve your experience!
Frequently asked questions from our users
Formfacade provides built-in date functions that can be used to update today's date, add or subtract dates & more. Here's the list of date functions:
Read the full article →You can use the TODAY function to update the current date as the answer to a date question in the form.
Read the full article →You can subtract the start date from end date to calculate the number of days between the dates. By default, the answer will be in milliseconds. You can divide by 24*60*60*1000 to convert it into days.
Read the full article →You can use the DIFF function to calculate the age based on the date of birth entered by the user.
Read the full article →You can use the ADD function to add days, months or years to a date. The add function can be used with an input date field or a calculated date field.
Read the full article →You can use the SUBTRACT function to subtract days, months or years from a date. The subtract function can be used with an input date field or a calculated date field.
Read the full article →You can use the ADD function to dynamically calculate the end date based on start date and duration selected by the user.
Read the full article →You can calculate the number of days in the month using DATE function and then subtract the current day of the month to calculate the days remaining in that month.
Read the full article →You can use the getDay() function to find the day of the week for a specified date. This function returns a number from 0 to 6 representing each day of the week from Sunday to Saturday respectively.
Read the full article →You can use the getDay() function to determine the day of the week for the current date and use the ADD function to calculate the start date and end date for the next week.
Read the full article →Google Forms does not support response validations for date questions. The workaround is to add a short answer question with the required response validations and add the calculations in Formfacade.
Read the full article →Google Forms does not support response validations for date questions. The workaround is to add a short answer question with the required response validations and add the date range calculations in Formfacade.
Read the full article →