Consulting

Results 1 to 4 of 4

Thread: Solved: Text to Number

  1. #1
    VBAX Regular
    Joined
    May 2004
    Posts
    42
    Location

    Solved: Text to Number

    I am using the following function to convert a date to a week of the year. The makes the result into text which I would like to have it as a numeric value. How do you convert it?

    Format([Actual_Shift_Start_Dt],"ww",7)

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Quote Originally Posted by bkudulis
    The makes the result into text which I would like to have it as a numeric value. How do you convert it?

    Format([Actual_Shift_Start_Dt],"ww",7)
    Format([Actual_Shift_Start_Dt],"ww",7)*1

    or

    Val(Format([Actual_Shift_Start_Dt],"ww",7))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    May 2004
    Posts
    42
    Location
    This is exactly what I was looking for thank you.

  4. #4
    Site Admin
    The Princess
    VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Nice, xld.

    bkudulis: I've marked this solved for you. Next time, you can just hit Thread Tools at the top of the page and mark it solved yourself. Thanks!
    ~Anne Troy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •