Friday, May 6, 2011

Open Office Base Datetime Default

Can anyone tell me how to set the default value on a date field in Open Office Base, in the same way that GetDate() works for SQL Server?

Cheers OneSHOT

From stackoverflow
  • Give CURDATE() a try.

    Found at http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures

    OneSHOT : +1 for being the only answer :-) but I no longer have access to the setup to test this. The project got canned and so did the dev machine!
    OneSHOT : I've created a test db just so i could close this off and it seems CURDATE() works! Cheers Richard.
    Richard West : Glad I could help

0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.