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.