Hi
Do you know if it is possible, either in Word, or in CMS009 to compare two dates? (like date a - date b = x days)
create virtual fields for each date and format the output as number, then make another field to make a final calculation.
easier for me to achieve in CMS , you need to create vitual field calculation , or if you would like to make calculation against current date you need to first make virtual field with current date.
I would try to use the date number field from CSYCAL. You would have to join it twice, and create a virtual field for the difference
Thanks for your reply
Trying this in CMS009 I see that I do not get expected result:
1. I made a virtual field, type calculation, doing the calculation of two dates (date a - date b = x days)
2. I printed the document and get wrong result: 06. march 2024 - 25. july 2024 = 419 days
Do you format the dates in any specific way before you use them for this kind of calculation?
That helped! Thanks a lot!
