A needed Date function

I can’t believe this function does not exist. Quite often I prepare and distribute a spreadsheet to others. I would like it to contain the date on which it was updated. The easiest thing would be to implement a function DATELASTSAVED(). Everything I can find about this suggests using a macro. However, a function would be a lot easier to use.

You might want to submit an enhancement bug here.

I am having the same problem with DATE_ADD and DATE_SUB functions - can we please, please get some more date functions??? I could do so much more if I had them…

One possible solution to your problem may be what I do in Base is a DATE field with DEFAULT CURRENT_DATE. Mind you, I use SQL so I’m not sure how you would do this in calc but this works excellent for a Date Modified field in any of my forms in Base where my clients want to know when the information was last updated. I am not sure if this will help you or not.
Cheers

A late answer attempt:)

Have a look at Menu:File->Properties. In the General section is a field “created” and “modified”. In the Custom Properties section you can add/select predefined fields or create your own fields.

@LibreLyrae: CURRENT_DATE is TODAY in Calc, if you means this. Don’t exactly understand what you mean with DATE_ADD and DATE_SUB. If you mean adding/substracting dates you can use the +/- with dates in a cell.

My issue is a Base one, which does not seem to allow the +/- usage with dates, I have tried. DATE_ADD and DATE_SUB are SQL functions supported in other SQL database engines but not currently supported in Base… Currently looking into making it a split database using HSQL 2.x instead. Sorry to be confusing Calc and Base in this topic.