The date type in an XLSForm

Development
1

Hi,

I am currently trying to calculate the date after a certain number of months after the initial date using an XLSForm. I set the type of the variable to calculate and plug in the calculation for the date. However, when I try to display the new date, it returns a long integer.

For example, if I set the initial date to October 23, 2015 and calculate the date 6 months later, it will return a value of 16737. Is there a way to change this integer value into the actual expected date?

Thank you,
Ryan

2

Hi,

I was able to figure it out. It was really easy and I don't believe it
took me that long to figure it out. You just need to put date() around the
calculation and it will change the type from string to a date type -_-

Ryan

ยทยทยท On Monday, October 19, 2015 at 11:50:33 AM UTC-7, Ryan Bendo wrote:

Hi,

I am currently trying to calculate the date after a certain number of
months after the initial date using an XLSForm. I set the type of the
variable to calculate and plug in the calculation for the date. However,
when I try to display the new date, it returns a long integer.

For example, if I set the initial date to October 23, 2015 and calculate
the date 6 months later, it will return a value of 16737. Is there a way to
change this integer value into the actual expected date?

Thank you,
Ryan