Hi
Robert Großkopf wrote
> you could use something like this:
> DATEDIFF('dd','1899-12-30',TODAY)+10
+1
Robert Großkopf wrote
> You could format the column to date and the GUI will change this to the
> date you want. But remember: The format of the query will never been
> saved. So it could only be usable in a form.
I think it will be saved if you create a view from the query, open the view,
then change the format.
Regards
Pierre-Yves
--
View this message in context:
http://nabble.documentfoundation.org/Date-manipulation-tp4126888p4126925.html
Sent from the Documentation mailing list archive at Nabble.com.
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted
