Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Date format

Discussion in 'Information Technology' started by Mr Johnson, Jul 28, 2006.

Tags:
  1. Mr Johnson

    Mr Johnson
    Expand Collapse
    Guest

    Hello,

    I have some work I import from text file, the date is format 01/31/05, I
    just want the Month and Year only? Please Help
    --
    Johnson II Johnson ESG Inc.
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    If the format is always mm/dd/yyyy, then you can try

    MyMonth: Left([FieldName],2)
    MyYear: Right([FieldName],4)

    If the field is a date field then you can try

    MyMonth: Month([FieldName])
    MyYear: Year([FieldName])

    --
    Good Luck
    BS"D


    "Mr Johnson" wrote:

    > Hello,
    >
    > I have some work I import from text file, the date is format 01/31/05, I
    > just want the Month and Year only? Please Help
    > --
    > Johnson II Johnson ESG Inc.
     

Share This Page