Date Validation

Question

Hi 
 we have a field on the opportunity screen (proposed date), the client wants to prevent users from entering dates in the past 
 is there any code i can use for this please? 
 Many Thanks 
 Sufyan

Vega · Answer

I'd use a validate script. You need to be mindful of the users date format preference. I'm not near my computer at the mo but that's the approach I'd use. Comparing dates is simple enough with a greater than or less than comparison

Vega · Answer

The problem you'll have is the user preferences setting because if the user has their date format preference set to something that you're not expecting you'll get errors. I've had a look at this but it started to get complicated due to the user preference setting. Ignoring it might be easy but any validate script shouldn't ignore it. 
 
 This works in validate scripts to get the preference: CRM.UserOption('NSet_UserDateFormat'); Then you'll need to get the two dates without the time element and then you can compare them.

Sage CRM

Date Validation

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING