Get current week number (year as in 1 to 52) - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Get current week number (year as in 1 to 52)

chris_hurleychris_hurley Posts: 37Member
Hi,

I am tring to create a query that searches for records where the week number that record was created is the same as the current date week number.

My plan was to have a field in the record for week number and then use that as my query criteria. Are there any functions that get the value of the current week that i can use in my create record query?

Im using SQL and VB6 studios. Please help

Chris

Comments

  • infidelinfidel Posts: 2,900Member
    : Hi,
    :
    : I am tring to create a query that searches for records where the week number that record was created is the same as the current date week number.
    :
    : My plan was to have a field in the record for week number and then use that as my query criteria. Are there any functions that get the value of the current week that i can use in my create record query?
    :
    : Im using SQL and VB6 studios. Please help

    Format(Date(), "ww")




    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

  • chris_hurleychris_hurley Posts: 37Member
    Legendary. Proper job, thanks infidel.
Sign In or Register to comment.