"FIRST_DAY" is not a Cognos function, but it appears to be a vendor-specific one in IBM DB2 (see,
https://www.ibm.com/support/knowledgecenter/SSCRJT_7.0.0/com.ibm.swg.im.bigsql.commsql.doc/doc/r0061474.html). What DB is your function running against?
In any event, per the above, "
BETWEEN FIRST_DAY(((CURRENT_DATE) + (-1) YEAR)) AND CURRENT_DATE" would mean FROM the first day of the current month one year ago TO the current day. For example, as I write this, today is 11/20/2020, so BETWEEN 11/1/2019 AND 11/20/2020 (including the start and end dates).------------------------------
Michael Walter
Business Analyst
TX HHSC
Austin
------------------------------
Original Message:
Sent: Wed November 18, 2020 07:00 AM
From: Priyanka Joshi
Subject: FIRST_DAY(((CURRENT_DATE) + (-1) YEAR)
hey,
can anyone please let me know meaning of following sentence.
BETWEEN FIRST_DAY(((CURRENT_DATE) + (-1) YEAR)) AND CURRENT_DATE
------------------------------
Priyanka Joshi
------------------------------
#CognosAnalyticswithWatson