Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session

Calculate the difference between two dates - in Years and Months - not days


Level 1

Let's keep this simple. I want to do THIS: Calculate the difference between two dates - Excel in LiveCycle. Is it possible?

Four columns. Two dates. Two different results:

Start Date/Time Field |  End Date/Time Field |  Years |  Months

Easy peasy.

I can't find a complete answer anywhere. I think this solution would help tons of people.

Thanks for your help!

1 Reply


Level 7

It would be possible. Need to use calculations to work it out. Use Date2Num to convert dates to numbers. I found the few times i used it, using FormCalc worked for me.