I have two functions, 1stReminder and 2ndReminder.
What I expect to happen is as follows:
o 1stReminder - Will return the Last1stReminderDate if it is greater than the LastPaymentDate or the LastPaymentDate is null.
o 2ndReminder - Will return the Last2ndReminderDate it is greater than 1stReminder and 1stReminder is not null
1stReminder
2ndReminder
At the moment it is not working.
Last1stReminderDate = 17/02/2004
Last2ndReminderDate = 17/03/2004
LastPaymentDate = 16/06/2004
In the following case 2ndReminder has a value of 17/03/2004 instead of null. 1stReminder appears to be null or at least balnk. How do I make it null?
What I expect to happen is as follows:
o 1stReminder - Will return the Last1stReminderDate if it is greater than the LastPaymentDate or the LastPaymentDate is null.
o 2ndReminder - Will return the Last2ndReminderDate it is greater than 1stReminder and 1stReminder is not null
1stReminder
Code:
[COLOR=blue]if[/color]
[COLOR=green]// If there are no payments or the 1st reminder date is since the last payment date[/color]
[COLOR=blue]isnull[/color]({Command.LastPaymentDate}) [COLOR=blue]or[/color] {Command.Last1stReminderDate} > {Command.LastPaymentDate}
[COLOR=blue]then[/color]
{Command.Last1stReminderDate}
Code:
[COLOR=blue]if[/color]
[COLOR=green]// If the previous formula is not null and the 2nd reminder was since the 1st[/color]
[COLOR=blue]not[/color]([COLOR=blue]isnull[/color]({@1stReminder})) [COLOR=blue]and[/color] {Command.Last2ndReminderDate} > {@1stReminder}
[COLOR=blue]then[/color]
{Command.Last2ndReminderDate}
At the moment it is not working.
Last1stReminderDate = 17/02/2004
Last2ndReminderDate = 17/03/2004
LastPaymentDate = 16/06/2004
In the following case 2ndReminder has a value of 17/03/2004 instead of null. 1stReminder appears to be null or at least balnk. How do I make it null?