Returns
True if date lies inside the
part of month containing basedate
up until and including the last millisecond of basedate.
Syntax:
InMonthToDate
(timestamp, base_date, period_no)
Return data type: Boolean
Arguments:
Arguments
Argument
Description
timestamp
The date that you want to compare with base_date.
base_date
Date that is used to evaluate the month.
period_no
The
month can be offset by period_no.
period_no is
an integer, where the value 0 indicates the month which contains base_date. Negative values in period_no indicate preceding months and
positive values indicate succeeding months.
Scripting examples
Example
Result
inmonthtodate ('25/01/2013', '25/01/2013',
0)
Returns True
inmonthtodate ('25/01/2013', '24/01/2013',
0)
Returns False
inmonthtodate ('25/01/2013', '28/02/2013',
-1)
Returns True
Example:
Add the example script to your app and run it. Then add the fields listed in the results column to a sheet in your app to see the result.
By specifying period_no as 4, this example checks if an invoice date falls in the fourth month after the month in base_date but before the end of the day specified in base_date.
TempTable:
LOAD RecNo() as InvID, * Inline [
InvDate
28/03/2012
10/12/2012
5/2/2013
31/3/2013
19/5/2013
15/9/2013
11/12/2013
2/3/2014
14/5/2014
13/6/2014
7/7/2014
4/8/2014
];
InvoiceData:
LOAD *,
InMonthToDate(InvDate, '31/01/2013', 4) AS InMthPlus42D
Resident TempTable;
Drop table TempTable;
The resulting table contains the original dates and a column with the return value of the inmonthtodate() function.
Results table
InvDate
InMthPlus42D
28/03/2012
0 (False)
10/12/2012
0 (False)
5/2/2013
0 (False)
31/3/2013
0 (False)
19/5/2013
-1 (True)
15/9/2013
0 (False)
11/12/2013
0 (False)
2/3/2014
0 (False)
14/5/2014
0 (False)
13/6/2014
0 (False)
7/7/2014
0 (False)
4/8/2014
0 (False)
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!
