Hi all,
I need to validate a customer date within a form. The rule is: date must be this year or last year.
I was not able to get this running.
My thoughts:
1. get customer date year
vCustomerDate = formatdate(CustomerDate, "yyyy")
2. get last year
vCustomerDateMinus1Year = vCustomerDate - 1
3. create string
vFirstDayLastYear = "01.01."&&vCustomerDateMinus1Year
4. Convert string to date
5. Compare CustomerDate with FirstDayLastYear
I was able to do the first two things, but failed with point 3.
Recommandations are really appriciated.
Cheers
mai-kel




