[Vtigercrm-developers] How to make reports with weekly data?

[Angelo Paglialonga]

Hi! If you’re using vtiger 7.4 you have a new expression regex for “update fields” task so that you can parse date fields according to your needs. I hope it helps. 

_______________

Angelo Paglialonga
Consulente per soluzioni CRM ad alto ROI.

Telefono: 3386077866
Skype: angelo.paglialonga
Web: https://www.angelopaglialonga.com


> Il giorno 28 ago 2021, alle ore 21:20, socialboostdk <socialboostdk at gmail.com> ha scritto:
> 
> 
> Hi there,
> 
> I'm trying to make a report with weekly data. Ie. how many deals are won every week, etc., without building a custom function.
> 
> I can't 100% figure out how to group them by weeks, so my thought was to make a new field called Weeknumber and then calculate the week number in that via a workflow with an "update field" expression. I could accept just having ie the amount of days gone this year and just divide with 7 for the week number.
> 
> But can I actually access the days/months/year of a date field in the expressions? I know there are several built-in date functions, but cant see that any of these can solve this case.
> 
> Thank you for any input :)
> 
> 
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210828/11f6388c/attachment.html>