How to count in which number a particular date will come

saurav4ss
Occasional Contributor

How to count in which number a particular date will come

Hi all,

I have a module in which a line item is date formatted and need to find in which week the dates will come as i have to calculate weekly average for all the weeks of a year.

Please suggest how to achieve this.

 

Thanks

1 REPLY 1
rob_marshall
Moderator

Re: How to count in which number a particular date will come

@saurav4ss 

 

Create a SYS Time Daily module with a line item named parent, formatted as week, with the formula being parent(item(time)).  Now, in the source module where you have a line item formatted as date, you can use that to do a lookup to the line item in the SYS Time Daily module.  Give that a shot.

 

Rob