DateTime Maximum function with data fields

  • 10 June 2015
  • 1 reply
  • 0 views

Badge +2

I cannot figure out how to use the DateTime Maximum function with multiple data fields.  I have 2 (DateTime) data fields that I want to get the maximum value.

The "values" field only lets you type a literal or drop in ONE field.  How can I create an array of my 2 fields?

 

Thank you!

 

14922i1529D58CA1CF2310.png


1 reply

Userlevel 1
Badge +8

Hi Mike

 

My understanding is that the "Values" field accepts a smartobject list method where a date field is returned. To use it this way you would use the context browser to select a smartobject list method and drag that into the field, and then configure the list method accordingly.

 

It looks like this is not how you want to use it, so perhaps look at using an IF function (found under logical folder) instead to compare the dates. Remember to change the return type to DateTime.

 

e.g.

 

Condition:  Date1 <= Date 2

True Value:  Date 2

False Value: Date1

Reply