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!

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

Playing with Functions

Status
Not open for further replies.
Joined
Oct 17, 2006
Messages
227
Sounds a stupid question

On the Title of a report I have

=CurrentDate()

Say I want to put Sales 06 07 23/02/06

="Sales 06 07 as of "+Currentdate()

incorrect data type??

do you need to convert it or am I being stupid???


 
You need to format the date as a string before you can concatenate it with another string. There is a seperate function for formating dates/numbers to a string format.
(no BO at hand, so can't indicate the exact function)

Ties Blom

 
Use the FormatDate function.

Steve Krandel
Symantec
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top