Week number in sql

Hello jee pee,

I'm a novice and I'm learning to use report builder as best as I can, I don't know what a DBMS is.

My problem is that I'm doing this in a variable and I'm getting an error message on all the codes I try, so I must not be doing things correctly.

I'm entering this code

begin

NumSem = Format(TaDate, "ww", vbMonday, vbFirstFourDays)

end;

error message undeclared label

Do we declare it in a variable or something else?

Thank you for your help.

Pascal

I am under Firebird, is that the DBMS?

Like Mr. Jourdain, you must use a Database Management System without knowing it ;-)

Firebird does seem to be a DBMS; you should look in its SQL for date retrieval commands.

--
        a foreigner is a friend we haven't met yet.

Hello,

Under Firebird (as with others ...), there is a manual and/or tons of tutorials available online that contain most of the answers... :-)
Here’s for you:
https://firebirdsql.org/refdocs/langrefupd21-intfunc-extract.html

https://firebirdpt.wordpress.com/2005/11/22/date-functions/

Something like

 EXTRACT( WEEK FROM CURRENT_DATE ); 

--
Best regards,
Jordane

Hello Jordane45,

Thank you for your help, I looked at the link, but I don’t have the skills to fully understand it, I will still try the code EXTRACT( WEEK FROM CURRENT_DATE );

I put this in a variable in Oncalc
begin

value end; EXTRACT( WEEK FROM CURRENT_DATE );

end;

and this one:

begin

value end; (EXTRACT(YEARDAY FROM D) – EXTRACT(WEEKDAY FROM D-1) + 7) / 7
end;

But no data is coming out.

I don’t know if I’m putting this in the right place.

I continue trying to understand what I’m doing...