Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose i have date from 01/04/2013 to 27/10/2014 ...Financial year is from April- March....
If i click on a particular date then i should get no. of days in that financial year.
For Example:- if i select 18/06/2013 then i should get 79
if i select 18/06/2014 then also i should get 79
Hi, you can use:
DayNumberOfYear(DateField, 4)
Hi,
you can use the below.
='18/06/2013'-Makedate(year('18/06/2013'),4,1)
replace the hardcoded date with field name of date field from where you are selecting the date.
As said DayNumberOfYear() will work.
agree
replace '18/06/2013' with your field and adapt the date format
=date#('18/06/2013', 'DD/MM/YYYY') - yearstart(date#('18/06/2013', 'DD/MM/YYYY'), 0, 4) +1
18/06/2013 --> 79
18/02/2014 --> 324
Please see the attached file