cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Validation rule if current or future month is selected?

Jump to solution

Hi,

 

I want to be able to trigger an error message if the selected month = current or future date(month).

Right now I have 

Control is invalid if:

Service Date(Column) == fn-FormatDate(Current Date,MM)

 

Im sure there is a better way to write this rule but would like some help.

Thank you.

Labels: (1)
0 Kudos
Reply
2 Replies
Highlighted
Automation Master
Automation Master

Re: Validation rule if current or future month is selected?

Jump to solution

@SpenSouv ......what's the value you get from service date? Complete date with time or just the month and if it's just the month then what's the value?

 

Also in formatdate function MM should be in double quotes i.e. "MM".

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Validation rule if current or future month is selected?

Jump to solution
0 Kudos
Reply