Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
So I have hard coded my upper and lower limit of my date value on my script in load editor. I later found that the year should be +1 every financial year (1st of July)
*For current year:
If (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) >= date('01/11/2019') and (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) <= date('31/10/2020') as Invoice_Group_A,
If (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) >= date('01/05/2019') and (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) <= date('30/04/2020') as Invoice_Group_B,
if (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) >= date('01/05/2018') and (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) <= date('30/04/2019') as Invoice_Group_C
*From 1st July 2021, all the year value should be changed to:
If (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) >= date('01/11/2020') and (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) <= date('31/10/2021') as Invoice_Group_A,
If (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) >= date('01/05/2020') and (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) <= date('30/04/2021') as Invoice_Group_B,
if (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) >= date('01/05/2019') and (Date(Date#(Invoice_dt,'DDMMMYYY'),'DD/MM/YYYY')) <= date('30/04/2020') as Invoice_Group_C
Could anyone please help how to set the year value to change depending of the current year. I also need the date and month stay the same.
Thank you.
Hi @BigKev
I understand Financial Years between 1st July - 30th June, what confuse me is the calendar limits in your script, as you are using 1st Nov - 30th Oct; Would you please elaborate more about these dates!
You need to implement a Master Calendar that will bridge these two calendar, but I could not guide you further with the information present in your post.
Hope this helps,