misssoysauce
Technical User
Hiya, I am creating a rental form for a colleague. They want pull-down boxes for Month, Date, and Year for the delivery and collection of an item. Then they want the form to automatically calculate the number of days an item was on hire.
1.How do I combine the data from the month, date, and year boxes into a recognized date field, (which would be hidden)
2.that I can perform simple calculations on?
I have done the individual combo boxes as general numbers, created a field that combines the numbers and formats to a date, but when I try to subtract, I keep getting an #Error message in the calculation field.
Thank you!!
1.How do I combine the data from the month, date, and year boxes into a recognized date field, (which would be hidden)
2.that I can perform simple calculations on?
I have done the individual combo boxes as general numbers, created a field that combines the numbers and formats to a date, but when I try to subtract, I keep getting an #Error message in the calculation field.
Thank you!!
