Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spshanth
Starting Member
3 Posts |
 Posted - 2008-10-21 : 08:18:23
|
| Hello All,I would like to know the query to accept the system date and to display the year alone as the default input in a text box. My query is:SET SYear = select TO_CHAR(sysdate, 'YYYY') from dual;SET StartMonth=upper(inputbox('Input Scheduled Start Month (YYYY/MM): ','Scheduled Start Date Prompt',?SYear'/01'));where SYear is the current year and i am trying to display the same in the input box as the deafault year. It should appear like 2008/01.will this query work?? can anyone help me??thanks in avance. :) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-10-21 : 08:39:32
|
| Post your question at Oracle ForumThis forum is specific to SQL ServerMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
To accept date and to display the same!!