Last run date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
its giving me an error, am i inputting wrong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
will the attached work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
wow this is way more complicated then i thought.