How to count in which number a particular date will come

saurav4ss
saurav4ss
in Modeling

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

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @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

Categories