Date function can be used to convert a year, month and day into a date. Syntax: DATE(year, month, day) where
Example usage: DATE(2020, 9, 25) DATE(2020, 12, 12)
Today function returns the current date. Syntax: TODAY()
NOW function returns the current date and time. Syntax: NOW()
Add function can be used to add seconds, minutes, hours, days, months or years to a date or date & time question. Syntax: inputdate.add(number, term) where
Example usage: TODAY().add(3,"days") TODAY().add(6,"months") TODAY().add(2,"years") NOW().add(3,"hours") NOW().add(25,"minutes") NOW().add(10,"seconds")
Subtract function can be used to subtract seconds, minutes, hours, days, months or years to a date or date & time question. Syntax: inputdate.subtract(number, term) where
Example usage: TODAY().subtract(3,"days") TODAY().subtract(6,"months") TODAY().subtract(2,"years") NOW().subtract(3,"hours") NOW().subtract(25,"minutes") NOW().subtract(10,"seconds")
Diff function calculates the number of seconds, minutes, hours, days, months or years between two date or date & time questions. Syntax: enddate.diff(startdate, unit) where
Example usage: TODAY().diff(DATE(1950,12,12),"years") TODAY().diff(DATE(2020,06,18),"months") TODAY().diff(DATE(2020,09,27),"days")
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to customize Google Forms.
Try It Free