[mv_clcdat]

Description

Link: [mv_clcdat]
Author: Marc Vos
Category: Date
Version: 8.x
License: Public Domain
Posted: Aug. 03, 2009
Updated: Feb. 09, 2011
More by this author...
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

02/09/2011, Marc Vos
Changes
Bug fixes & added (day in year or date) of monday of a week (WM & WMD).
Email:


Password:



Newest

Most Popular

Support tagSwap.net