If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help please with nested iif
Hi
I am trying to create a nested iif, for the following scenerio - but I am having difficulties if due date is less than today, show yesterdays date. if due date is between today and today plus 14 days, show the current due date. if due date is greater than today plus 14 days, show the current due date plus 15 days. I have managed the basic iif (true/false), but cant evaluate the rest! Many Thanks Alec |
#2
|
|||
|
|||
Help please with nested iif
alecgreen wrote:
| I am trying to create a nested iif, for the following scenerio - but I | am having difficulties | | if due date is less than today, show yesterdays date. | if due date is between today and today plus 14 days, show the current | due date. | if due date is greater than today plus 14 days, show the current due | date plus 15 days. IIF([Field1]date(); date()-1; IIF(Field1]=date() and [Field1]=date()+14; date(); date()+15 ) ) -- KN |
#3
|
|||
|
|||
Help please with nested iif
On 3 Mar, 08:32, "Krzysztof Naworyta"
wrote: alecgreen wrote: | I am trying to create a nested iif, for the following scenerio - but I | am having difficulties | | if due date is less than today, show yesterdays date. | if due date is between today and today plus 14 days, show the current | due date. | if due date is greater than today plus 14 days, show the current due | date plus 15 days. IIF([Field1]date(); * * * * date()-1; * * * * IIF(Field1]=date() and [Field1]=date()+14; * * * * * * date(); * * * * * * date()+15 * * * * * * ) * * ) -- KN Brilliant, Thanks |
Thread Tools | |
Display Modes | |
|
|