Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

inserting current date

Status
Not open for further replies.
Christi

Christi

Programmer
Dec 28, 2001
14
0
0
US
can anyone please tell me how to display current date on forms block.
I have almost completed my forms design.
However, I need to have the current display on the forms main menu screen.
any ideas will be greatly appreciated.
christi
 
Sort by date Sort by votes
HI..Try this..

In side : When_New_form_Instance Trigger

Select sysdate into :DateBox from Dual;
 
Upvote 0 Downvote
Thank you very much intervb!
That is exactly what I want.
Thanks again
c
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

deeptic
  • Locked
  • Question
Displaying Date & Time when the form is run
Replies
1
Views
52
sem
sem
aspiringprog
  • Locked
  • Question
day of week conflicts with Julian date
Replies
2
Views
76
aspiringprog
aspiringprog
kss444
  • Locked
  • Question
problems with different date formats in same field.
Replies
2
Views
52
carp
carp
cwsstins
  • Locked
  • Question
Insert Date for Log
Replies
3
Views
25
cwsstins
cwsstins
wwworg
  • Locked
  • Question
Error on Insert sql statement (Date field)
Replies
1
Views
23
lewisp
lewisp

Part and Inventory Search

Sponsor

Back
Top