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

string error

Status
Not open for further replies.
296097

296097

Programmer
Aug 13, 2004
32
US
I am using this formula and i am getting string required error.I do not really know why i am getting this error.to me every thing looks fine and should work, if any body has an idea let me know pls.
here is the formula:totext(dtstodate({PLANHOLD.DATEPUR}),"yy/dd/MM")
 
Sort by date Sort by votes
That would suggest that your date field is already a date. Try removing the dtstodate() function.

-LB
 
Upvote 0 Downvote
It works ok now. thank you for your prompt reply LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
432
LauraW
LauraW
GCL2007
  • Locked
  • Question
Extracting from string 1
Replies
8
Views
271
GCL2007
GCL2007
supportsvc
  • Locked
  • Question
Combine Multiple If Statements as Single String? 1
Replies
7
Views
338
supportsvc
supportsvc
clara1
  • Locked
  • Question
unable to add formula field as it displays error 1
Replies
3
Views
166
kray4660
kray4660
TMasterK
  • Locked
  • Question
Showing Duplicates but starting with the second character not the first (string)
Replies
1
Views
117
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top