How to count in which number a particular date will come
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.
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.