To find day of year using formulae

HCL Domino Domino Forum
1

Hi,

Can u help me to write a formulae to get the day of the year. For e.g.

If Feb 03, 2004, it should show 34.

If Feb 10, 2004 it should show 41.

Thank u in anticipation,

Fraser Noronha

2

Subject: To find day of year using formulae

something like…@If(datefield=“”;0;1+(datefield-@Date(@Year(datefield);1;1))/86400)

3

Subject: RE: To find day of year using formulae

Thank u Sir,

It works,

Fraser Noronha

4

Subject: To find week of year using formulae

Very cool. Thus, you can use this as a home-grown @week function:

tmpLastOf:= @Adjust( dateField; 0; 0;

  @Select( @Weekday(dateField); 6; 5; 4; 3; 2; 1; 0 );0;0;0);

@Integer( @If(tmpLastOf=“”;0;1+(tmpLastOf-@Date(@Year(tmpLastOf);1;1))/604800) );