Number of days from current selection of date

[#1]

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

[rubenmarin · Accepted solution]

Hi, you can use:

DayNumberOfYear(DateField, 4)

[#3]

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.

[#4]

As said DayNumberOfYear() will work.

[jpenuliar]

agree

[maxgro]

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

[Kushal_Chawda]

Please see the attached file