The eccoMAGIC Forums

The eccoMAGIC Forums
http://forums.eccoMAGIC.com/forum/YaBB.pl
the SLANG EXTENSION and Guest Programming >> Slang Rules Scripts, Functions, Examples and HOW TO >> Getting Started Tutorial on dates
http://forums.eccoMAGIC.com/forum/YaBB.pl?num=1204834480

Message started by Admin on 03/06/08 at 14:14:40

Title: Getting Started Tutorial on dates
Post by Admin on 03/06/08 at 14:14:40

In many cases, you can put a simple expression into a date folder to capture dates included in item text:

get_contain_date()

but that doesn't work so well with 'special cases' (such as Paypal transaction lists),

and, that doesn't help us understand how to TAKE CONTROL OF THE SLANG RULES.

so...

here are two simple functions that I use,

and a brief tutorial about what's going on.

Quote:

++:+!:{3} + imatch("JAN01FEB02MAR03APR04MAY05JUN06JUL07AUG08SEP09OCT10NOV11DEC12",left({1},3) + "(\d+)") + right("0" + {2},2):ITT ~= "^\s*([A-Za-z]+)\.?\s+(\d+),\s*(\d+)"

Quote:

++:!+: replace({1},"(\d\d)/(\d\d)/(\d\d\d\d)","$3$1$2",1):ITT ~= "^[^\d]*([\d/]+)"

In the first example we use a TABLE LOOKUP to convert a month (jan, january, etc.) to a numerica value 1-12.

that value is then sequenced after the year, and before the date (padded with 0).

In the second example, we grab the first instance of numbers slashes, and then use the replace function to change the order (and remove the slashes) to place in ecco 'date' format to be used in date folders.

Still confused ?

Ask, and your questions will be answered !

Title: Re: Getting Started Tutorial on dates
Post by Admin on 02/12/17 at 16:28:10

The expression also works to compute dates (in ecco date ready format)...

for example,

get_contain_date(Today - 33)

which will give you the date, 33 days ago....

:o