LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  finding max date, min date

    Employee
    Posted 07-02-2014 03:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sree

    Hi Team,

    What is the function for finding max date and min date from some date values.

    Example
    2014-06-09
    2014-03-31
    2014-03-17
    2014-04-01

    From the above date values for finding out max date,min date which function need to use in Filter node.

    Thank you for all your support.
    Regards,
    Sree.


  • 2.  RE: finding max date, min date

    Employee
    Posted 07-03-2014 18:19

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: xathras

    Sree, you wouldn't use a filter node to do that. I'd recommend an agg ex node, sort by value of 1 (all) and then the following as code in the agg ex:

    minDate = groupMin(Example)
    maxDate = groupMax(Example)

    emit minDate, maxDate

    All the best
    Wayne


  • 3.  RE: finding max date, min date

    Employee
    Posted 08-03-2014 00:56

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: andycooper

    You could also use the Data Analyser Node (Profiling and Patterns); this will also convert your data to the correct format if it has been loaded from a CSV or Excel file and shows null values and checks for distinct values.