How to count in which number a particular date will come

Question

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

rob_marshall · Answer

@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