Home › Browse Extensions

DateTime2

by re-Solutions Software Test
(2 votes)
OOo_DateTime2.jpg

Version 2.0.1 2007-08-15
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 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"

Download extension
Operating System: System Independent
Official release: 2.0.1
Date: 2007-Oct-23
Size: N/A
View all releases
License: opensource
Further product information: Product details
Provider: re-Solutions Software Test
Report abuse here | Contact extension owner
  • 20214 downloads initiated
  • 352 downloads this week

Comments

Mon, 06/23/2008 - 18:07 — ziomaul

addition

Please addition routine "Table of valor":

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

Dim iMonth as Integer

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

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

Thank !

Thu, 10/18/2007 - 13:29 — drashok

To Winfried Rohr

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

Mon, 10/22/2007 - 00:35 — probe1

Customising insert formats

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?