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 wOOdy-Soft 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.
Oct 17, 2006
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top