Hi there,
I would like to use a checkbox control to prioritize a Target date value. The default value is:
If(Form_New,Text(DateAdd(Today(),30),DateTimeFormat.ShortDate),Form_Record.TargetCompletionDate)
This will add 30 days to Today's date and return a Target Completion Date.
Now I would like to add only 7 days instead of 30, when the priority checkbox is checked:
If(Form_New && Priority_value.Value ,Text(DateAdd(Today(),7),ShortDate),Form_Record.TargetCompletionDate)
How do I know combine the two in my default date property?
Thank You
Solved! Go to Solution.
Try this:
If(Form_New,Text(DateAdd(Today(),If(Priority_value.Value, 7, 30)),DateTimeFormat.ShortDate),Form_Record.TargetCompletionDate)
Hope this helps.
Try this:
If(Form_New,Text(DateAdd(Today(),If(Priority_value.Value, 7, 30)),DateTimeFormat.ShortDate),Form_Record.TargetCompletionDate)
Hope this helps.
User | Count |
---|---|
229 | |
99 | |
96 | |
56 | |
33 |
User | Count |
---|---|
280 | |
110 | |
109 | |
63 | |
62 |