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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-04-24 : 10:35:21
|
| Hi Guys,I want to get in my footer of the report date and time seperately when the report is printed. if the report is printed today, i need to get todays date and time. for example i want to look exactly in the below way in the footer of my report:Date: 4/24/2008 Time: 10:33:05 AMthe above names Date and Time are not any of field names or column names.any clues how to do it???Thanks,Raaj. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-24 : 12:00:46
|
| Try:- ="Date: " & FormatDateTime(Now(),0) & " Time: " & FormatDateTime(Now(),3) |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-04-24 : 19:23:12
|
| Thanks for ur reply...i tried ur code... ="Date: " & FormatDateTime(Now(),0) & " Time: " & FormatDateTime(Now(),3)when i did that one,for this part... FormatDateTime(Now(),0)...i am getting date along with time...so i tried putting 1 and 2 instead of 0....and 2 worked correctly which gives me only date....and the rest is perfect...thanks once again...raaj... |
|
|
|
|
|
|
regarding date and time???