Sometimes my formula works in my reports and sometimes it doesn't can you help me? ToText({Table.ReferralDate}, "MMM dd, yyyy")
Here's the error message:
Too many arguments have been given to this function. Details: errorKind Error in File RptClientListMasterByHousingOutcomeDischarge {E7A034BB-B776-40C2-BC59-DADA6B620520}.rpt: Error in formula Referral Date: 'ToText({Table.ReferralDate}, "MMM dd, yyyy")' Too many arguments have been given to this function. Details: errorKind
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 08 Feb 2011 at 3:45am
It looks correct, but if {Table.ReferralDate} is not always a datetime field, then you might get an error like this...I guess. Just because it says it's a referral date doesn't mean that some bonehead programmer forgot to make it so in the database...it might just be a text field.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
