Last run date

Hello, I'm trying to run my report weekly and i want the dates to only pick from the last run date.

I have a formula in there that runs the report from the 1st of the month, but when i run the report i need the report to only pick up the report from the last time i ran it. Would this possible?

Date Time

Accepted answers

All comments

DataNath

Hey @ntudev are you able to share a few more details about how you bring in the report etc? I'm guessing you save all of your runs somewhere and then currently use a Dynamic Input tool for the one which ran at the start of the month?

If you use a Directory > Dynamic Input combination then you could just add a sort after the Directory tool, descending on CreationTime and then a sample tool to only keep the First N rows (N = 1).

Something like this:

Luke_C

Hi @ntudev

Some more info would be helpful. I'm interpreting it a bit different than @DataNath. If you need to filter from the last time you ran the WF, you probably need to output a yxdb file with a date time field (created using the datetimenow() function). Then bring that in as an input to leverage in your filter.

ntudev

well lets say i ran the report as of June 10th which had the entered date of june 6 thru june10, then on june 17th i ran the report again for entered date of june 13th thru june 17th. I just want the entered date to be after the las time i ran the report. does it make sense?

rundate.xlsx

DataNath

Hey @ntudev, from the example you’ve provided, it looks like you could just use a Filter tool with the expression:

DateTimeParse([Cmmt Entered Date], ‘%d/%m/%Y’) > DateTimeParse([Report Run Date], ‘%d/%m/%Y’)

The data you want will come out of the top (true anchor).

ntudev

its giving me an error, am i inputting wrong

DataNath

Oh sorry, I opened it in Excel originally so the date formatting was different. You don't actually need the DateTimeParse() functions, can just use: [Cmmt Entered Date]>[Report Run Date]

However, that's also incorrect as it's comparing it to the date of the same run (i.e. that dataset), rather than the previous. You could pull in the previous by doing something to the dynamic input I mentioned earlier, trimming down your previous run input so you only have the date ran field and then append that to the new run, before applying this formula. If you can provide an example of a new run and a previous I can build something for you.

ntudev

will the attached work?

rundate.xlsx

DataNath

Something like this? You'd need to reconfigure the Directory, Dynamic Input and Input Data tools to match your own folders/filepaths of course.

Check last run date vs entered date.yxmd

ntudev

wow this is way more complicated then i thought.

DataNath

Unless I'm missing something and the run date of the previous run already comes in as part of the new data set, you'll need to dynamically bring this in separately in order to compare them.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335