+10Hello all,
Do we have a function in Acumatica that we pass a date and returns the WeekID which is used in EPTimeCard.WeekID? The format of WeekID stored in DB I see is “YYYY##” which ## is a sequential counter. I see Acumatica is using EPWeekRaw that has some properties including Start and End Date but I need it opposite. I have the date and I need the equivalent WeekID. I can calculate the Week # but I want to be consistent with what Acumatica does. considering Acumatica has Custom Weeks
Best answer by aaghaei
I got it, it is PXWeekSelector2Attribute.GetWeekID(MyDate)
+10I got it, it is PXWeekSelector2Attribute.GetWeekID(MyDate)
Thank you for sharing your solution with the community
Is there something similar to be used in reports? I would like to join the ARTranDate to the DateInfo DAC so I can get the WeekEnding ID and group by the WeekEndingID only I can’t because it is non existent. Is there an alternative? I need a report that has sales #’s by week for the past 5 weeks. Thanks.
+10please have a look at the below post. It might be helpful. Report Designer is not my strong suit and honestly I’m not interested in it so I have not spend much time on it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
