I need to get the week out of the year depending on the date, how could I?
In the UI, you can click on
Add Field and user the following sql:
That will get you the week number (1-52) of a given DATE, TIME or DATETIME field.
hey men thank you, It works very well.