| View previous topic :: View next topic |
| Author |
Message |
cowboy1611
General User
Joined: 01 Nov 2011
Posts: 21
|
 Posted: Fri Mar 30, 2012 5:41 am Post subject: Date field |
 |
|
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 |
|
 |
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Fri Mar 30, 2012 7:15 am Post subject: |
|
|
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 |
|
|
cowboy1611
General User
Joined: 01 Nov 2011
Posts: 21
|
| Posted: Fri Mar 30, 2012 8:43 am Post subject: |
|
|
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 |
|
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Fri Mar 30, 2012 8:55 am Post subject: |
|
|
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. 
Sliderule
Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved. |
|
| Back to top |
|
|
cowboy1611
General User
Joined: 01 Nov 2011
Posts: 21
|
| Posted: Fri Mar 30, 2012 9:05 am Post subject: |
|
|
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 |
|
|
cowboy1611
General User
Joined: 01 Nov 2011
Posts: 21
|
| Posted: Mon Apr 02, 2012 8:56 am Post subject: |
|
|
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 |
|
|
|
|
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
|
