If condition
Application Type
Traditional Web

i want to write a condition for date of birth(DOB) need to be before current date and date of death(DOD) need to be later than date of birth(DOB).

for example DOD>DOB. 

Solution

Where do you want to do the condition, on an aggregate?


If so you have built-in functions to give you the current date. As CurrDateTime() and CurrDate()


With that, it will be possible to do that verification in an aggregate.

You add a filter and you add the condition


dateofbirth<CurrDateTime() and dateofdeath>dataofbirth

The CurrDate is to compare with variables or attributes with data type date and CurrDateTime is to compare with attributes with data type date time.

You can see the descriptions of each function.

Kind Regards,

Márcio

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.