Free Date Difference Action Plugin

[Worm]

After reading the post in beta forum, I thought I'd give this a whirl.

This plugin is called DateDiff and will let you easily add or subtract days, months, or years to/from a date.

Take it while ya can...

Unzip the DateDiff.zip and copy it to your Plugins\Actions
folder then fire up the sample app.

So for AMS it would be something like this:
C:\Program Files\AutoPlay Media Studio 5.0 Professional\Plugins\Actions\DateDiff

Be gentle now, this is my first real go at a true action plugin.

[Intrigued]

Very useful Worm and thanks.

Seems to work properly right from the get go.

[Worm]

Here's an updated version.

Added:
DateDiff.GetDayOfWeek
returns a numeric value representing the day the date passed falls on
(Sunday = 1 ... Saturday = 7)

DateDiff.GetDifference
returns the number of days between two dates.

Unzip and copy over the existing plugin files.

[TJ_Tigger]

Another great addition to WormWare

[csd214]

DateDiff.GetDayOfWeek
returns a numeric value representing the day the date passed falls on
(Sunday = 1 ... Saturday = 7)

Worm, I can’t resist to tease you:

Sunday isn’t the first day in the week in all counties. In Norway it is the 7th day!

Thanks for all your gifts. Have a nice day.

[Worm]

Well...

I actually was thinking a little about that. That's why I returned a numeric rather than a string. I was going to return "Monday", "Tuesday", etc.. but thought if I returned a numeric, the user could create a table with their own strings for different languages. The date format being US (MM/DD/YYYY) I'm kind of stuck with as the C++ class I'm using only excepts the date in US format.

This is a test plugin for me. I'm trying to take some of the knowledge I gleaned from Brett when working on the DataGrid and put it to use. If there is a way to make this better, please say so, and I'll see what I can do.

[Worm]

Another update:

Added:
DateDiff.FormatSeconds

takes the number of seconds passed, and formats it into a string HH:MM:SS

[dthompson16]

Good going, Worm. What I had in mind was a duplicate of the DateDiff function in VB. The syntax for which is in attached .png.

[dthompson16]

BTW, Worm, since you have modified your date difference plugin a couple of times, do you happen to have full documentation for it that I can keep in one place handy for reference? Thanks. Glad to see someone out there eats code that is breakfast of champions, ditto Tigg. Even Excel spreadsheets have this function, so it will be great to have something similar for Six.

[Worm]

The help file should be up to date with the latest additiions.

[csd214]

the user could create a table with their own strings for different languages

YES; no problem! (… and you have an example in your help file). I was joking; tried to.

BTW I had to do the same “adjustment” when working with a language delivered by a well known vendor (with address Redmond)).

It’s really nice to have these commands integrated in AMS. LuaCom has some helpful functions for local date formats.

t = os.date('*t')  -- time now [table elements hour, min, wday, year, yday, month, sec, day]
-- some adjustments needed because the result is displayed in an object with input mask ##/##/####
if String.Length(t.day) == 1 then 
	t.day = "0"..t.day;
end
if String.Length(t.month) == 1 then 
	t.month = "0"..t.month;
end
Input.SetText("inpLocaleDate", t.day.."."..t.month.."."..t.year);

[Worm]

I knew you were jabbing me a little csd214.

But to be honest when it comes to international dates, you're absolutely right, I'm clueless.

[dthompson16]

Yes, thank you, I printed out your help file. Nice. One final question: what will DateDiff.GetDifference do if I attempt to enter a date that's not on the calendar like Feb 29, 1999 or Aug 33, 2005?

[Worm]

In a perfect world it should return -1 for an invalid date format, but I just tried it and it gave me a result.

I'll look into it when I get a chance.

[dthompson16]

10-4. Thanks again. I'll stay tuned in.