I am having a hard time with the now() function in calc. I have a column with the date in yyyy-mm-dd format. I need another column that shows the difference between now() and that column, and if the difference is negative (that means that the date has passed) it will show the text "expired". I have tried playing with the if function and I have gone through all the possibly related function in the official list [1] however this seemingly-simple exercise eludes me. Maybe I need more coffee?
[1] http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
