Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

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

Avatar

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

Avatar

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.