kdavis6416
Technical User
I am looking to create a Date parameter to dispay the YTD to be July 2011 to current.. Our Calendar year here is Jul - Jun.. not Jan to Dec.. So I cannot use the standard YTD function.. make sense...
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Function (datevar v_inputdate)
local datevar v_fiscalstart;
local datevar v_fiscalend;
if month(currentdate) in [1 to 6]
then
v_fiscalstart := date(year(currentdate) - 1,7,1)
else
v_fiscalstart := date(year(currentdate),7,1);
if month(currentdate) in [1 to 6]
then
v_fiscalend := date(year(currentdate),6,30)
else
v_fiscalend := date(year(currentdate) + 1,6,30);
if v_inputdate in v_fiscalstart to v_fiscalend then true else false;