Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I saw people having doubt in InYearToDate function. So here I am describing it please leave a comment on this.
SYNTAX: InYearToDate (timestamp, base_date, period_no[, first_month_of_year])
timestamp: consist of the date field or the date you want to check
base_date: Consist of that date up-to which you want the date range should be.
period_no[, first_month_of_year] : Consist of the following value
-1 -> Preceding Year
0 -> Current Year
1 -> Succeeding Year.
Now I will show you one example to describe better:
suppose you have the following data in your Edit Script:
Table1:
Load * inline [
Doj, Name
03/30/2015, Sachin
03/31/2015, Lee
04/01/2016, Rahul
03/30/2016, Raymond
03/31/2016, Virat
04/31/2015, Raunak
02/20/2015, Sahil
];
Table2:
LOAD
Doj,
InYearToDate(Doj,'03/31/2016',0) as CurrentYearFlag,
InYearToDate(Doj,'03/31/2016',-1) as PreviousYearFlag
Resident Table1;
Case1: InYearToDate (Doj,'03/31/2016',0)
Here the Date period range is from 01/01/2016 to 03/31/2016.
a) if Doj=03/30/2015 (doesn't comes within the date range) hence the value returned is 0(False)
b) if Doj=03/30/2016 (comes within the date range) hence the value returned is -1(True)
Case2: InYearToDate (Doj,'03/31/2016',-1)
Since -1 indicates previous Year, hence here the Date period range is from 01/01/2015 to 03/31/2015.
a) if Doj=04/20/2015 (doesn't comes within the date range) hence the value returned is 0(False)
b) if Doj=03/30/2015 (comes within the date range) hence the value returned is -1(True)
Case3: InYearToDate (Doj,'03/31/2016',1)
Similarly, Here the Date period range is from 01/01/2017 to 03/31/2017.
It seems the document should be put on "Documents" or "blog posts", but I appreciate it.
It seems the document should be put on "Documents" or "blog posts", but I appreciate it.