Ask Your Question
0

A needed Date function [closed]

asked 2012-10-24 01:45:02 +0200

Al gravatar image

updated 2015-10-26 00:52:20 +0200

Alex Kemp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 00:52:42.277601

3 Answers

Sort by » oldest newest most voted
1

answered 2012-10-24 16:32:45 +0200

horst gravatar image

You might want to submit an enhancement bug here.

edit flag offensive delete link more
0

answered 2013-03-02 17:37:52 +0200

horst gravatar image

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.

@Libre Lyrae: 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.

edit flag offensive delete link more

Comments

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.

Libre Lyrae gravatar imageLibre Lyrae ( 2013-03-02 20:18:38 +0200 )edit
0

answered 2013-03-02 14:51:37 +0200

Libre Lyrae gravatar image

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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-10-24 01:45:02 +0200

Seen: 260 times

Last updated: Mar 02 '13