It would be nice to be able to use a dynamic file with a date as a condition.

E.g.

if File Exists C:\Archive\<YYYY>\<MM>\TheFilename_<YYYYMMDD>.txt

Anything in <angle brackets> is substituted with the current date.

In addition to this, it would be good to be able to offset the date value.

I've developed a token language that allows to dynamically offset a date. See attached file.

where's the file?

where's the file?

Attached now. I've developed a simple way of expressing relative dates based on adjustment tokens and alignment tokens. The document does job of describing it. I also have some C# code if you want that. Let me know.

That is some good stuff.
I've been having to do my own version of this that is not as 'user friendly' and very rudimentary.
Could you let me look at your c# code?

Thanks!!

That is some good stuff.
I've been having to do my own version of this that is not as 'user friendly' and very rudimentary.
Could you let me look at your c# code?

Thanks!!

See attached files. Renamed to ".txt" to upload.

When using generic dates that involve "business" days, you need to use a Calendar object to define what the holidays are. A simple "NoHolidayCalendar" has been attached as an example.

that's some slick coding you got there.
very nice.
it would definitely make it alot easier to deal with scheduling if they would implement it in VisualCron.

It would be nice to be able to use a dynamic file with a date as a condition.

E.g.

if File Exists C:\Archive\<YYYY>\<MM>\TheFilename_<YYYYMMDD>.txt

Anything in <angle brackets> is substituted with the current date.

In addition to this, it would be good to be able to offset the date value.

I've developed a token language that allows to dynamically offset a date. See attached file.

If I understand you correctly you can already do this with VisualCron Variables like this:

C:\Archive\{DATEFORMAT(yyyy)}\{DATEFORMAT(MM)}\TheFilename_{DATEFORMAT(yyyyMM)}.txt

---

If I understand you correctly you can already do this with VisualCron Variables like this:

C:\Archive\{DATEFORMAT(yyyy)}\{DATEFORMAT(MM)}\TheFilename_{DATEFORMAT(yyyyMM)}.txt

That's neat. I'll give it a try. Although, would be cleaner as:

C:\Archive\<yyyy>\<MM>\TheFilename_<yyyyMM>.txt
(Windows doesn't allow angle brackets, so it's a good choice. Not sure about Linux or if VC supports Linux).

Thanks.

I was thinking in terms of offsetting date variables taking weekends, holidays and month/year boundaries into account.
I am currently having to put in logic, for instance, to get all the files in a directory that were created in the month of May to zip them up. You currently only allow ">" and "<" as the allowed operators. So, I can't get the stuff that was created on the 1st of the month and then I have to go to the following month and use the 1st day to get the right boundaries for this type of functionality.