Date of created file

[D Soyars]

I am trying to "timestamp" just the date "current date" at the creation of a new file only

[UnklDonald418]

A DateTime field is basically a tick counter. It is a floating point number with the number of days since December 31, 1899 to the left of the decimal point and the number of milliseconds since midnight to the right of the decimal point.
A Date control on a Base form has a number of formatting options that allow display of only the date portion of a timestamped DateTime field.

You can specify a CURRENT_DATE constraint then timestamp times will always be set to 0 (12:00 AM).
If your table already has a Date/Time field then modify the following SQL template

Code: Select all

ALTER TABLE "YourTableName" ALTER COLUMN "ExistingDate/TimeColumn" SET DEFAULT CURRENT_DATE;

Be sure to keep a backup of your original table in case something goes awry. Execute the SQL statement at Tools>SQL, then select View>Refresh Tables to complete the update.

[UnklDonald418]

It just occurred to me that you could use the same SQL statement on a Date field. That would essentially result in a date stamp.

[D Soyars]

Thank you for your reply
I tried it and it wont work the whole program crashes

[UnklDonald418]

According to your signature you are using OO on a Windows 10 platform. If OO is frequently crashing then make sure you have all the latest Windows updates installed and it might be worthwhile to upgrade OO to version 4.1.6
On the Performance tab the Windows Task Manager (<Ctrl><Shift><Esc>) displays the resources monitor. Make sure you aren't running out of memory
If the problem persists the try Libre Office.
https://www.libreoffice.org/download/download
There is no immediate need to delete OO because OO and LO can both be installed on the same computer.