Provider:
re-Solutions Software Test
Maintainer:
probe1
Rating:
3
Average: 3 (3 votes)
Application:
Calc, Writer
Tags:
writer, , calc, , date, , time, , timestamp,
Post date:
Sunday, 16 September, 2007 - 19:48
Statistics
Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
System Independent version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

Version 2.0.3 2008-10-13
Provides six functions to insert date or time or timestamp, as text / string or field / value, in Writer / Calc,
Pre-formatted to user needs ( ISO8601 format, adjustable) with German locale strings, English format notation in source: just un-comment.


This extension will install a Basic library/modules with the BASIC macros. They can be used for keyboard shortcut or customized toolbar assignment, or to run them from menu.




For Calc documents, you can configure to overwrite (replace) or add insertion to any existing cell content. Position (pre/post) and separators can be defined.
User-defined text can be added, too, to get something like "Call entered at: 2007-10-24 12:34:56"


2011-03-01 Extension still working on OOo3.2

DateTime2

Version Operating system Compatibility Release date
2.0.3 System Independent -- 14/10/2008 - 06:48 More information Download
2.0.1 System Independent -- 22/10/2007 - 17:55 More information Download

Comments

Hello Winfried,

I strived one full day to be able to get date and time together
in a single click in openoffice.org writer.

I wanted date field or time field to show all of this in a single click:

NNNNMMMMDD, YYYY HH:MM AM/PM

In the Insert menu ---> Fields -----> Other ----> Fields box opens and in the first column ---> Document under Type
I clicked ---> Date.
I went in ----> additional formats made the necessary change
then -----> clicked Insert.

However, "Select" column shows "Date" and when I want date on my writer page, I am always getting the text 'Date' and not the date itself.

I thought that after installing your extension the above situation will get corrected.
I will get back at least the functional default 'date', I hoped, but in vain.

Working at it has not helped me solve the problem. I am at an impasse.

I will appreciate if you spare your valuable time and help me resolve this so that on clicking 'date' I do not get the text 'date'.

Best regards,
Dr. Ashok Koparday
-Offending URL removed- by Administrator TBO

Dear Ashok,

as described in the document you can change the source to get "your" date or time format:
Open the Basic editor (Tools>Macros>Organise Macros>OpenOffice.org Basic) then locate the DateTime2 library with DateTime module.

At top of the source code you'll find three constant strings, which determines the formats to use:

MYDATEFORMAT
MYTIMEFORMAT
MYTIMESTAMPFORMAT

Change the format strings to your needs - and installed locale language.
English formats are included as a sample - others you will find in OOo Help (F1)

Does this solve you problem?

Hello Winfred,

I am consistently pestered by a problem for which I have spent days trying to resolve.

What happened
I went to Insert -> Fields -> Other -> Date -> Additional Formats.

What is the problem
I am persistently getting the word 'date' instead of the date.

What I tried to resolve
* I have made the necessary changes in macros as you described.
* Removing and reinstalling Open Office from Add/Remove Program has not helped.

What I want
I want date and time in one click NNNN MMMM DD, YYYY HH:MM AM/PM
I use Open Office Writer.

What needs to be done
My software 'language' knowledge is zero.
I pray you to guide me.

I am waiting for your kind reply.

Dr. Ashok Koparday
ask[at]mydoctortells[dot]com

This is an older post, but if anyone has this same issue, here's the answer:

The steps that Dr. Koparday list are instructions to insert a date field into the body of a Writer document. This is native to Writer, and really doesn't apply to the DateTime2 extension.

If you insert the date into the document like this and see the text "Date" or "Date (fixed)", this is a setting within Writer itself. Under "View" choose "Field Settings" (or Ctrl-F9) -- you should see the text "Date" change to the actual date, or vice-versa.

Please addition routine "Table of valor":

///////////////////////////
Sub MonthCurrent

Dim iMonth as Integer

iMonth = DatePart("m", Now)
Print iMonth

End Sub
/////////////////////

Thank !

The cumbersome configuration process has cost me at least two hours of frustration, and I have not got what I want. I have changed the variables mentioned to
public Const MYDATEFORMAT = "NNNN MMMM DD, YYYY"
public Const MYTIMEFORMAT = "HH:MM" [unchanged]
public Const MYTIMESTAMPFORMAT = "NNNN MMMM DD, YYYY HH:MM"

The Datum_Feld, Zeit_Feld and Zeitstempel_Feld macros now work as expected, but the Datum_Text and Zeitstempel_Feld macros still return the date in the format 2009-10-25, completely useless to me.

What further steps are necessary to configure the _Text macros, please?

Kimmus

Configration of the TEXT return values is made within the DateTime2_func module from line 169 on.

Please use the "Contact the author" link if you have questions or problems... I don't visit the Extension Website often, as you see :)

i setup the format of my time stamp to be HH:MM:SS

it's showing up great in the sheet, but I couldn't understand the values showing in the formula bar and somehow it messes up the end result in formula with other cells. Like in the sheet i'm showing 4:58:26, but in the formula bar it shows up as 983620:58:26. And I couldn't get the results that I want using this timestamp. Please I need your kind help, I know nothing much about programming so if you would be kind to explain it in detail.

I would like the time on the formula bar to be the same with the one showing in the cell just like as if i'm typing it manually. Thanks.

The insert value is NOW, formatted as time.

This means, the internal value is not only the time now, it's the date and time value.

Within the cell it's shown as time, the formular bar shows the value of the date, too.

I have no problem doing time calculations with that value (if all cells are formatted as TIME).

To discuss this problem further, please go to http://www.oooforum.org (English) or http://de.openoffice.info (German language), sign in and create a thread in CALC section, appending a document showing your problem. Thanks.