If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Determine the date for the Friday of a given Year and week Number
If on my report I have the Year in field Txt_Year and I have the Week Number
in field Txt_Week, what function can i use to determine the datae for Friday. Example Txt_Year returns 2005 Txt_Week returns 20 I need a text box named Txt_Date to return 5/13/2005 which is the corresponding Friday for those Year and week Number Parameters. How can i do this? Thanks -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
"DoctorV3774 via AccessMonster.com" wrote:
If on my report I have the Year in field Txt_Year and I have the Week Number in field Txt_Week, what function can i use to determine the datae for Friday. Example Txt_Year returns 2005 Txt_Week returns 20 I need a text box named Txt_Date to return 5/13/2005 which is the corresponding Friday for those Year and week Number Parameters. How can i do this? Thanks weekday(yourweek, vbfriday) -- _ _ Ciao MAssimiliano Amendola www.accessgroup.it Cisa - Conferenza Italiana per Sviluppatori Access Info: www.donkarl.com/it |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Figuring fiscal year based on formatted date | cherman | General Discussion | 2 | June 1st, 2005 01:21 AM |
Date value in page header for a year ago (month and year only) | ChuckW | Setting Up & Running Reports | 5 | May 20th, 2005 11:49 PM |
Join 2 Tables with query problem | ShyGuy | Running & Setting Up Queries | 3 | October 14th, 2004 04:24 AM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
type date and year has to come. | shital | Worksheet Functions | 6 | October 6th, 2003 01:49 PM |