Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: Please Help with Date Formula

    Thank you for your help
    Im trying to make my date field that looks like

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12


    To look like this

    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Set
    Oct
    Nov
    Dec

    What formula would I use?

    Thanks again
    TCB

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if the numeric value is coming from a date column then...
    =month(<myvalue>)
    =month(<mycolumn)
    if not a custom function woudl do the job
    private function GetMonmth(value as integer) as string
    select case value
    case is 1: GetMonth = "Jan"
    case is 2: Getmonth = "Feb"
    ...adn so on
    case is 12: GetMonth = "Dec"
    case else
    GetMonth = "How the heck do I know"
    end select
    end function

    then call the getmnth function as =getmonth(<value>)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Dec 2008
    Posts
    10

    Sorry if I did not understand

    Maybe I do not understand your question so I apologize if that's the case, but there's a built-in function "format" that you can use in queries, reports, modules and even when creating (or modifying) a table structure.

    Again, sorry if I did not get your question properly (but if I did and you need more info, feel free to ask)

    BR,
    Faik

Posting Permissions

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