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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula ... Year?

Status
Not open for further replies.
vbjohn

vbjohn

Programmer
Aug 23, 2001
67
US
When I run the Syntax check it gives me a message saying "a Text is required here" and it highlights the whole Year function...

MonthName(Month ({SlsInquiry.DateSales}), True) + ". " + Year({SlsInquiry.DateSales})
 
Sort by date Sort by votes
Try:

MonthName(Month ({SlsInquiry.DateSales}), True) + ". " + totext(Year({SlsInquiry.DateSales}),0,"")

or use:

MonthName(Month ({SlsInquiry.DateSales}), True) & ". " & Year({SlsInquiry.DateSales})

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
497
hilfy
hilfy
MusicMan123
  • Locked
  • Question
Record Selection Formula Help
Replies
0
Views
249
MusicMan123
MusicMan123
sofseattle
  • Locked
  • Question
Formula to convert value to run time time field
Replies
2
Views
356
SkipVought
S
rwwagner
  • Locked
  • Question
Passing date range formula from main report to sub report
Replies
2
Views
600
lbass
lbass
nerdygirlgear
  • Locked
  • Question
Formula evaluating a list of 50 values that are strings.
Replies
1
Views
212
1tufgt
1tufgt

Part and Inventory Search

Sponsor

Back
Top