Data Integration
- Data Integration
- All Products
MAX(date[,filter_condition] )
Argument
| Required/
Optional
| Description
|
---|---|---|
date
| Required
| Date/time data type. Passes the date for which you want to return a maximum date. You can enter any valid transformation expression.
|
filter_condition
| Optional
| Limits the rows in the search. The filter condition must be a numeric value or evaluate to TRUE, FALSE, or NULL. You can enter any valid transformation expression.
|
MAX( ORDERDATE, ITEM_NAME='Flashlight' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
The Return value answer to your example is missing.
Hello again, Jocelyn. We have confirmed with our QA team that the return value in this example will be "Sep 21 1998." We will update the documentation to include the return value. You should see the update in the next monthly release.
Thanks so much for reaching out, Jocelyn! We are currently verifying the correct return value and will get back to you.
Sincerely,
Informatica Documentation Team