Get first monday of week from a week number ?

gazpacho

Hi

Is there a quick way to retrieve the date of the first monday of a week when the only thing known is the week number and the year ?

Thanks in advance

Gazz

Tim81

Hi,

there is a possibility. Use the table "Date". Set "Period Type" = Week (e.g. Date.SETRANGE("Period Type",Date."Period Type"::Week);).

Then set a filter for "Period Start" to the needed year ("01.01.05..31.12.05"). Then look for the right "Period No." and the given "Period Start" is the first day of the week!

FPulsfort

This gives the help:

DWY2DATE
Use this function to return a date based on a weekday, a week, and a year.

Date := DWY2DATE(WeekDay [, Week] [, Year]))
Date

Data type: date

The resulting date.

Weekday

Data type: integer

The number of the day in the week (1..7). Monday is day number 1.

Week

Data type: integer

The number of the week. January 1 falls in week number 1. If you omit this optional parameter, the system uses the current week as the default.

Year

Data type: integer

The four-digit number of the year. If you omit this optional parameter, the system uses the current year as the default.



Hope this helps.

Greetings,
Frank

gazpacho

Thanks Frank, works perfectly. Should've found this one out myself, though :?