Last Date

user07905
user07905 ⚪️
in Magic ETL

If I have a dataset and I want to pull the last date information how do I do that?

Comments

  • KVincent
    KVincent 🟡

    You can use the max function in best mode to return last date. Is there a little more information on what you are trying to do specifically?

  • user07905
    user07905 ⚪️

    Some of the data I receive is not always timely.  I won't get our files for some of our monthly data for April 30th until May 5-10th.  How do I get the card to pick up the last value I have (March 31 and update when I have April 30)

Categories