CRM On Demand - Administration (MOSC)

MOSC Banner

Field Validation on Date field - Multiple languages

edited Dec 4, 2013 7:22AM in CRM On Demand - Administration (MOSC) 7 commentsAnswered
 Hi All,
We have a field validation rule on one of the date fields on opportunity object that actually checks and throws error if that date is greater than today's date, if the opportunity is at certain sales stage(In this case Closed stages). We also have various sales processes with their own sales stages. The problem we are having is that this validation rule is not working with the users whose language is not English. Below is the expression that we are using:

(IIf([<SalesStage>]='Closed/Won' AND [<CloseDate>]>Today(),'Error',IIf([<SalesStage>]='Closed/Lost' AND [<CloseDate>]>Today(),'Error',IIf([<SalesStage>]='Awarded' AND [<CloseDate>]>Today(),'Error',IIf([<SalesStage>]='Decision' AND [<CloseDate>]>Today(),'Error',IIf([<CloseDate>]<[<IndexedDate0>],'Error',IIf([<CloseDate>]>[<dAnticipated_Order_Date_I_ITAG>],'Error',[<CloseDate>])))))))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center