Hi Andrew;

  Considering the PB product's maturity, you would think that it would have a NumberOfWeeks() method but it does not. I would suggest though that you create a support ticket for this as an enhancement request.

In the meantime, I've always just used the DBMS's "week" related SQL support. For example:

SA: https://help.sap.com/docs/SAP_SQL_Anywhere/93079d4ba8e44920ae63ffb4def91f5b/81ffeccd6ce21014aa8fd702987f065e.html

SS: https://learn.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

Check your DBMS documentation for your DB's specific support. HTH

Regards ... Chris 

Hi Andrew,

In addition to John's PFC suggestion - and not sure what database you might be using - most databases have built-in functions providing this capability (EG DatePart() for SQL Server and PostgreSQL).

HTH...regards,

Mark

Hi, Andrew -

If you have access to the PowerBuilder Foundation Class (PFC) libraries, the non-visual object pfc_n_cst_datetime in the pfcapsrv.pbl contains a method named of_WeekNumber that does what you want.

The code depends on a small number of other object functions within the same NVO.

The PFC libraries can be obtained from here:

    https://github.com/OpenSourcePFCLibraries

Best regards, John

Hi Andrew,

If you're not afraid of trying something new, C# makes this very easy. You would just have to create a small C# library and use it on PowerBuilder.

Regards,
Francisco