Obtain week of a date

I need to get the week out of the year depending on the date, how could I?

Hi,

In the UI, you can click on Add Field and user the following sql:

date_part('week', "my_date_col")

That will get you the week number (1-52) of a given DATE, TIME or DATETIME field.

1 Like

hey men thank you, It works very well.