[SOLVED] How to copy-paste the result of =TODAY() as a date?

Discuss the spreadsheet application

[SOLVED] How to copy-paste the result of =TODAY() as a date?

Postby raschumacher » Wed Jul 03, 2019 9:16 pm

Is there a way to copy from a cell which contains the formula =TODAY() and paste only the value (that is, date) of that formula into another cell? None of the "Paste Special" options and none of the combinations of options that I have tried works; the "Number" option, both by itself and with the "Format" option, does paste the date number, but not in date format.

As a workaround, is there an inverse function of DATEVALUE("text") ? That is, a function which converts a date number into a date?
Last edited by robleyd on Thu Jul 04, 2019 1:32 am, edited 3 times in total.
Reason: Add green tick
OpenOffice 4.1.7 on macOS High Sierra 10.13.6
raschumacher
 
Posts: 3
Joined: Wed Jul 03, 2019 8:49 pm

Re: How to copy-paste the results of =TODAY() as a date?

Postby Zizi64 » Wed Jul 03, 2019 9:22 pm

The LibreOffice Calc has "insert fixed date" feature.

Or you can cut (Ctrl-X), and then Paste special/Unformatted text (Shift-Ctrl-V) the date value created by the Today() function.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8546
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: How to copy-paste the results of =TODAY() as a date?

Postby RusselB » Wed Jul 03, 2019 9:24 pm

The Paste Special with the number option checked will paste a static number that can be formatted using the Format Cells (Ctrl+1) options, so that you see the date in the format that you want.
If you have the cells already formatted as you want the display, leave the format option unchecked, that way the format used will be the format already applied to the cell.
There is no reverse for the DATEVALUE function in Calc, unless you want to write a macro that performs that job.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5689
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: How to copy-paste the results of =TODAY() as a date?

Postby raschumacher » Wed Jul 03, 2019 9:33 pm

Thanks. Pre-formatting the target cell, or changing the format after pasting the value (the date number), does indeed work.
It seems to me a bug that the date format cannot be special-pasted along with the value, but oh well :_>
OpenOffice 4.1.7 on macOS High Sierra 10.13.6
raschumacher
 
Posts: 3
Joined: Wed Jul 03, 2019 8:49 pm

Re: How to copy-paste the results of =TODAY() as a date?

Postby Villeroy » Wed Jul 03, 2019 9:57 pm

Paste special "Date+Time" and "Formatting" works with LibreOffice 6.1
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27384
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [SOLVED] How to copy-paste the result of =TODAY() as a d

Postby MrProgrammer » Mon Jul 08, 2019 5:26 pm

raschumacher wrote:As a workaround, is there an inverse function of DATEVALUE("text") ? That is, a function which converts a date number into a date?
Read section 3. Dates in cells in Ten concepts that every Calc user should know. A date number IS a date. You need to make your goal clear.

If you want the cell's value to be the numeric date but you want the cell to display the year/month/day instead of the number, read section 2. Controlling how data is displayed in the tutorial. Use the Date category and select the format. Use the General category to format the cell.

If you want the cell's value to be text instead of a number, use the TEXT function.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3898
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: [SOLVED] How to copy-paste the result of =TODAY() as a d

Postby raschumacher » Tue Jul 09, 2019 12:02 am

The exact thing required is: Copy -> Paste Special -> select "Date & Time" & "Formats". Then the date number is pasted with the source format. My bad. Thanks all for the help.
OpenOffice 4.1.7 on macOS High Sierra 10.13.6
raschumacher
 
Posts: 3
Joined: Wed Jul 03, 2019 8:49 pm


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 32 guests