Calculating Field

[Abbosy]

Good day Forum


I have an "ExtendedWarranty" that is calculating ([DateExtendedWarrantyTaken] + [NumberOfYearsExW] * 365)

DateExtendedWarrantyTaken =Date().

This is working fine until "InitialWarranty" exceeds "DateExtendedWarrantyTaken".

I need your help guys to set my extended warranty to work like:

If "InitialWarranty" is > "Today'sDate" then to replace the original calculation with:

[(InitialWarranty] + [NumberOfYearsExW] + 365)

or indeed I'm sure you have better advice to do this.

Many thanks to you all and best regards


Abbosy

 

[pr2-eugin]

Are you trying to Store this value in table? If so then you have to stop doing this.. If in a Query you can do this..

ExtendedWarranty : IIF([InitialWarranty] > Date(), ([InitialWarranty] + [NumberOfYearsExW] + 365), ([DateExtendedWarrantyTaken] + [NumberOfYearsExW] * 365))

 

[Abbosy]

Thanks a lot for your help Paul

It's really helped a lot.

Regards
Abbosy

 

[pr2-eugin]

No problem !