OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Date field

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
cowboy1611
General User
General User


Joined: 01 Nov 2011
Posts: 21

PostPosted: Fri Mar 30, 2012 5:41 am    Post subject: Date field Reply with quote

I have a table set up with a field for the date.

I would like to get the date input upon data entry, via the form (or any other way) automatically.

Possibly when the form is chosen, it could input the date, or when I select the date box...
currently, I have it where I can choose the date or select "todays" date, just trying to simplify it more.

Any ideas

p.s. this is for Date only, not Time.
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Mar 30, 2012 7:15 am    Post subject: Reply with quote

cowboy1611:

You said / asked:

cowboy1611 wrote:
I would like to get the date input upon data entry, via the form (or any other way) automatically.

Possibly when the form is chosen, it could input the date, or when I select the date box...
currently, I have it where I can choose the date or select "todays" date, just trying to simplify it more.

This can be accomplished at the database level. See the post below, and, look at the information provided by user Sliderule.

http://www.oooforum.org/forum/viewtopic.phtml?t=117321

The above will include a table rule, when nothing is entered as a value for the given DATE field, it will 'default' to the computer's current date ( database value of CURRENT_DATE ). Also, be sure to modify any forms already created as described in Step 4 by Sliderule.

I hope this helps, please be sure to let me / us know.

Sldierule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
cowboy1611
General User
General User


Joined: 01 Nov 2011
Posts: 21

PostPosted: Fri Mar 30, 2012 8:43 am    Post subject: Reply with quote

Thanks Sliderule, I looked briefly at the post and then the other posts/links....
I'll have to sort thru all that and see if I want to attempt it.

This seems like it should be an simple option either in the data type field or the form...
i.e., a simple choice, be able to select/change the date OR go with current date stamp...

Now to continue my rant...

Is OO a Windows product or clone ??? it must be , to have to go thru coding convulsions for something that seems very basic is frustrating....
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Fri Mar 30, 2012 8:55 am    Post subject: Reply with quote

cowboy1611:

cowboy1611 wrote:
Now to continue my rant...

Is OO a Windows product or clone ??? it must be , to have to go thru coding convulsions for something that seems very basic is frustrating....

Please, rant all you want, and, I hope you feel better as a result.

I have no reason to waste any of my time to respond to rants . . . ergo . . . I have no reason to be be subject to rants from you in the future . . . so . . . I will never respond to you in the future. Sorry I tried to help, certainly my mistake. It will not happen again. Smile

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.
Back to top
View user's profile Send private message
cowboy1611
General User
General User


Joined: 01 Nov 2011
Posts: 21

PostPosted: Fri Mar 30, 2012 9:05 am    Post subject: Reply with quote

Sliderule.

no offense to you was meant........ and thanks for your help.
Again, no offense to you and if it came across that way
I apologize for the confusion.

AS I mentioned I'll look in to the pointers you mentioned.



My rant was just a frustration of the product.
Back to top
View user's profile Send private message
cowboy1611
General User
General User


Joined: 01 Nov 2011
Posts: 21

PostPosted: Mon Apr 02, 2012 8:56 am    Post subject: Reply with quote

For the record.

As you can see, I apologized to Slide rule twice in my post to this thread.

First of all I think my comment was clearly aimed at the product NOT anyone's
advice/help , and that it was a stretch to take it that way..... however in the medium of
FONT, things can get perceived differently than if you were speaking directly to someone.

But since Sliderule took it that way I did apologize.
Also, since I wasn't sure that he/she would read the thread, I sent a PM and
apologized again.

Below - for the record - is the response I got back from the PM
Once again, I apologize, to any and all. If Sliderule refuses to accept
I can only assume there aren't 2 adults in the room....

The PM is here
-----------
to Sliderule

See my last post...... (wanting Sliderule to see my apology in the post)



cowboy1611 wrote:
This seems like it should be an simple option either in the data type field or the form...
i.e., a simple choice, be able to select/change the date OR go with current date stamp...


Since it is simple, I look forward to seeing your new version of OpenOffice with this "simple option" included.

Since, I do not want to cause you any frustration, NEVER, NEVER, NEVER send me a Private Message, since I never want to cause you any frustration.

As I stated, I do not want to cause you any frustration, so, I will NEVER respond to you.

Sliderule
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group