[mv_clcdat]
Description
This tag is for handling dates entered by users, showing dates to users and do some date calculations, like leapyear, last day of month, difference in days, hours, minutes. etc. Here are some examples of what it can do for you (left of the colon is the fed date, right side is the result):
Action = FS
31082005 : 20050831
08312005 : 0
9082005 : 20050809
9.8.2005 : 20050809
9/8/2005 : 20050809
090805 : 20050809
90805 : 20050809
9.8.05 : 20050809
9/8/05 : 20050809
9-8-2005 : 20050809
9-8-05 : 20050809
nul : 0
niks : 0
Action = FSD
31082005 : 20050831
08312005 : 0
908205 : 0
9.0.2005 : 20050209
0/8/2005 : 0
000805 : 20050809
90005 : 20050209
9.8.05 : 20050809
9/8/05 : 20050809
9-8-00 : 20110809
9-0-00 : 20110209
nul : 0
niks : 0
Action = TS
20051223 : 23-12-2005
2005-12-23 : 23-12-2005
2005.12.23 : 23-12-2005
2005/12/23 : 23-12-2005
nul :
niks :
Action = EX
20051223 : 20051223
2005-12-23 : 20051223
2005.12.23 : 20051223
2005/12/23 : 20051223
51223 : 20051223
5/12/23 : 20051223
nul : 0
niks : 0
Action = LY
1996 : 29
19971200 : 28
19981223 : 28
1999-12-23 : 28
2000.12.23 : 29
2001/12/23 : 28
21223 : 28
3/12/23 : 28
4-12-23 : 29
nul : 0
niks : 0
Action = LD
20040223 : 20040229
2004-03-23 : 20040331
2004.04.23 : 20040430
2004/05/23 : 20040531
40623 : 20040630
4/07/23 : 20040731
nul : 0
niks : 0
Action = **
Today : 20110209
Action = **S
Today : 20110209231120
Action = DF
2004-02-12 08:00:00 - 2004-02-25 21:30:00 : array: (13), (13), (30), (00)
2004-02-25 21:30:00 - 2004-02-12 08:00:00 : array: (-13), (-13), (-30), (-0)
2000-01-01 21:30:00 - 2000-01-01 08:00:00 : array: (-0), (-13), (-30), (-0)
2000-01-01 21:30:00 - 2000-01-01 22:11:00 : array: (0), (00), (41), (00)
Action = AD & SD
2004-02-12 08:00:00 + 1 day, 20 minutes : 20040213
2004-02-25 21:30:00 - 1 day, 20 minutes : 20040224
2000-01-01 21:30:00 + 1 month, 1 week, 10 minutes : 20000208
2000-01-01 21:30:00 - 1 month, 1 week, 10 minutes : 19991125
mv_clcdat(-action='**') - 130 days : 20101002
mv_clcdat(-action='**') - 45 days : 20101226
mv_clcdat(-action='**') - 15 days : 20110125
Action = ADS & SDS
2004-02-12 08:00:00 + 1 day, 20 minutes : 20040213082000
2004-02-25 21:30:00 - 1 day, 20 minutes : 20040224211000
2000-01-01 21:30:00 + 1 month, 1 week, 10 minutes : 20000208214000
2000-01-01 21:30:00 - 1 month, 1 week, 10 minutes : 19991125212000
Action = SP
2001-01 : array: (0020), (01), (01), (00), (00), (00)
2001-01-01 : array: (2001), (01), (01), (00), (00), (00)
2002-02-02 02 : array: (2002), (02), (02), (02), (00), (00)
2003-03-03 03:03 : array: (2003), (03), (03), (03), (03), (00)
2004-04-04 04:04:04 : array: (2004), (04), (04), (04), (04), (04)
20050505050505 : array: (2005), (05), (05), (05), (05), (05)
200606060606 : array: (2006), (06), (06), (06), (06), (00)
2007070707 : array: (2007), (07), (07), (07), (00), (00)
20080808 : array: (2008), (08), (08), (00), (00), (00)
200909 : array: (0020), (09), (09), (00), (00), (00)
Action = WM
2001-01 : 2001001
01-02 : 2001008
200202 : 2002007
03 : 2011017
53 : 2010361
Action = WMD
2001-01 : 20010101
01-02 : 20010108
200202 : 20020107
03 : 20110117
53 : 20101227
Parameters
-date1
string, optional
Date to perform actions on
-date2
string, optional
A second date to calculate the difference with
-action
string, required
The action to perfom
Sample Usage
Action = FS<br>
9.8.2005 : [mv_clcdat(-date1='9.8.2005', -action='FS')]<br>
<p> </p>Action = FSD<br>
9.0.2005 : [mv_clcdat(-date1='9.0.2005', -action='FSD')]<br>
<p> </p>Action = TS<br>
20051223 : [mv_clcdat(-date1='20051223', -action='TS')]<br>
<p> </p>Action = EX<br>
2005-12-23 : [mv_clcdat(-date1='2005-12-23', -action='EX')]<br>
<p> </p>Action = LY<br>
1996 : [mv_clcdat(-date1='1996', -action='LY')]<br>
19971200 : [mv_clcdat(-date1='19971200', -action='LY')]<br>
19981223 : [mv_clcdat(-date1='19981223', -action='LY')]<br>
<p> </p>Action = LD<br>
20040223 : [mv_clcdat(-date1='20040223', -action='LD')]<br>
2004-03-23 : [mv_clcdat(-date1='2004-03-23', -action='LD')]<br>
<p> </p>Action = **<br>
Today : [mv_clcdat(-action='**')]<br>
<br> Action = **S<br>
Today : [mv_clcdat(-action='**S')]<br>
<p> </p>Action = DF<br>
2004-02-12 08:00:00 - 2004-02-25 21:30:00 : [mv_clcdat(-date1='2004-02-12 08:00:00', -date2='2004-02-25 21:30:00', -action='DF')]<br>
2004-02-25 21:30:00 - 2004-02-12 08:00:00 : [mv_clcdat(-date1='2004-02-25 21:30:00', -date2='2004-02-12 08:00:00', -action='DF')]<br>
2000-01-01 21:30:00 - 2000-01-01 08:00:00 : [mv_clcdat(-date1='2000-01-01 21:30:00', -date2='2000-01-01 08:00:00', -action='DF')]<br>
2000-01-01 21:30:00 - 2000-01-01 22:11:00 : [mv_clcdat(-date1='2000-01-01 21:30:00', -date2='2000-01-01 22:11:00', -action='DF')]<br>
<p> </p>Action = AD & SD<br>
2004-02-12 08:00:00 + 1 day, 20 minutes : [mv_clcdat(-date1='2004-02-12 08:00:00', -action='AD', -day=1, -minute=20)]<br>
2004-02-25 21:30:00 - 1 day, 20 minutes : [mv_clcdat(-date1='2004-02-25 21:30:00', -action='SD', -day=1, -minute=20)]<br>
2000-01-01 21:30:00 + 1 month, 1 week, 10 minutes : [mv_clcdat(-date1='2000-01-01 21:30:00', -action='AD', -month=1, -week=1, -minutes=10)]<br>
2000-01-01 21:30:00 - 1 month, 1 week, 10 minutes : [mv_clcdat(-date1='2000-01-01 21:30:00', -action='SD', -month=1, -week=1, -minutes=10)]<br>
mv_clcdat(-action='**') - 130 days : [mv_clcdat(-date1=mv_clcdat(-action='**'), -action='SD', -days=130)]<br>
<br> Action = ADS & SDS<br>
2004-02-12 08:00:00 + 1 day, 20 minutes : [mv_clcdat(-date1='2004-02-12 08:00:00', -action='ADS', -day=1, -minute=20)]<br>
2004-02-25 21:30:00 - 1 day, 20 minutes : [mv_clcdat(-date1='2004-02-25 21:30:00', -action='SDS', -day=1, -minute=20)]<br>
2000-01-01 21:30:00 + 1 month, 1 week, 10 minutes : [mv_clcdat(-date1='2000-01-01 21:30:00', -action='ADS', -month=1, -week=1, -minutes=10)]<br>
2000-01-01 21:30:00 - 1 month, 1 week, 10 minutes : [mv_clcdat(-date1='2000-01-01 21:30:00', -action='SDS', -month=1, -week=1, -minutes=10)]<br>
<br> Action = SP<br>
2001-01 : [mv_clcdat(-date1='2001-01', -action='SP')]<br>
2001-01-01 : [mv_clcdat(-date1='2001-01-01', -action='SP')]<br>
2002-02-02 02 : [mv_clcdat(-date1='2002-02-02 02', -action='SP')]<br>
2003-03-03 03:03 : [mv_clcdat(-date1='2003-03-03 03:03', -action='SP')]<br>
2004-04-04 04:04:04 : [mv_clcdat(-date1='2004-04-04 04:04:04', -action='SP')]<br>
20050505050505 : [mv_clcdat(-date1='20050505050505', -action='SP')]<br>
200606060606 : [mv_clcdat(-date1='200606060606', -action='SP')]<br>
2007070707 : [mv_clcdat(-date1='2007070707', -action='SP')]<br>
20080808 : [mv_clcdat(-date1='20080808', -action='SP')]<br>
200909 : [mv_clcdat(-date1='200909', -action='SP')]<br>
<br> Action = WM<br>
2001-01 : [mv_clcdat(-date1='2001-01', -action='WM')]<br>
01-02 : [mv_clcdat(-date1='01-02', -action='WM')]<br>
200202 : [mv_clcdat(-date1='200202', -action='WM')]<br>
03 : [mv_clcdat(-date1='03', -action='WM')]<br>
53 : [mv_clcdat(-date1='53', -action='WM')]<br>
Action = WMD<br>
2001-01 : [mv_clcdat(-date1='2001-01', -action='WMD')]<br>
01-02 : [mv_clcdat(-date1='01-02', -action='WMD')]<br>
200202 : [mv_clcdat(-date1='200202', -action='WMD')]<br>
03 : [mv_clcdat(-date1='03', -action='WMD')]<br>
53 : [mv_clcdat(-date1='53', -action='WMD')]<br>
<br>
Source Code
Click the "Download" button below to retrieve a copy of this tag,
including the complete documentation and sample usage shown
on this page. Place the downloaded ".inc" file in your
LassoStartup folder, restart Lasso, and you can begin using this
tag immediately.
mv_clcdat.lasso.zip (5.14 kb)
Comments
Changes
Bug fixes & added (day in year or date) of monday of a week (WM & WMD).