I have two date fields with a calculation field to determine the total days between the two, using the code:

= (DepartureDate-ArrivalDate).TotalDays

The calculation field is a number type, but the result always shows a decimal result and I can't find a way to force it to be a whole number. I've tried the Int32.Parse method but it doesn't change anything. Giving the field a Text type works okay, but then I can't use the result in another calculation further down the form.

Any ideas please?

1 Answer 1


One option would be to add an additional calculation field to represent the numeric value that is set to Show This Field - Never. This field will only be available in calculations, so will not affect the layout of your form.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.