How to found latest date.

Comments

3 comments

  • Avatar
    Tim Segall

    Kristian,

    *** The following answer assumes you are on 3.1.6 ***

     

    Take the above output and output it into an Aggregate node.  Set the GroupBy to 'name' and the Operation to be Max of login and you should get what you want.

    Note: This assumes your login field is a date, if it is not you will need to use the Data Analyzer to convert to a date before passing into the Aggregate node.

    Regards, Tim.

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Further to Tim's answer see the attached example data flow.

    The example shows how the Aggregate node's max operator is used to find the latest date. Dataverse 3.1.6 is required as it provided the grid-based editor to simplify the configuration of the Aggregate node.

    The example also shows how the formatted date string can be converted to a date type field using the Python strptime() operator, see here for details.

    You will need Dataverse 3.1.6 to import the .lna  file.

    Attached files

    Find_latest_date - 27 Nov 2017.lna

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    You may also be interested in the 'Working with Untidy Date Values' post.

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk