How i can constrain a datefield to be today or 5 days max before?

LouisDECOMBE

hi, 

Is there someone to help me on constraint with date field.

I've a datefield and i want that the user put a date that would be the d-day or 5 days before the d-day max.

I've tried with : >now() +5*24*60*60*1000, but does not function.

Thank you for your help.

A french guy!

JamesTedrick

Hi Louis,

So the valid dates are from today -5 days?  In that case you would need a compound statement to set lower and upper bounds:

int(.) >= int(today()) - 5*24*60*60*1000 and int(.) <= today(.)

So it must be greater than or equal to 5 days ago and less than or equal to today.