How to add datetime\addWeeks to formula

[Nishan Perera]

Hi,

I need some help on "datetime\addWeeks" since I want to show the week number of the created date on call. Could you please help me on this ? I have tried on formula, but no idea how to do that. Please help.

Thank you.

[Nishan Perera]

Any help on this ?

[Maximus]

Hi there,

> I want to show the week number of the created date on call

There is no such Formula. You need either develop it or create a hook with the SQL query.
This might be helpful:
- https://dev.mysql.com/doc/refman/8.0...ion_weekofyear
- https://dev.mysql.com/doc/refman/8.0...#function_week

[item]

Hello,

just create a formula (maybe exist out-of-box ). .. just in php return :


http://week-number.net/programming/w...er-in-php.html

or something like this :

date("W", $yourdate)

[Nishan Perera]

Maximus item Thank you for the above support. will work on that.