Results 1 to 5 of 5

Thread: [RESOLVED] How to format to Just Year in MS Access

  1. Nov 8th, 2005, 05:05 AM #1
    FishGuy
    FishGuy is offline

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Resolved [RESOLVED] How to format to Just Year in MS Access

    Hi,
    I have a date value i.e 29/09/2005,
    I understand that I can format this in the underlying query to be just 2005. So I can Order by it.
    Reply With Quote Reply With Quote
  2. Nov 8th, 2005, 05:06 AM #2
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: How to format to Just Year in MS Access

    have you tried Year(Field)?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
  3. Nov 8th, 2005, 05:11 AM #3
    FishGuy
    FishGuy is offline

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: How to format to Just Year in MS Access

    In the query designer in the field column it tried
    YEAR(DATE OF DELIVERY)
    It tells me the expression I entered contains invalid syntax.
    Reply With Quote Reply With Quote
  4. Nov 8th, 2005, 05:13 AM #4
    FishGuy
    FishGuy is offline

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: How to format to Just Year in MS Access

    Works.
    InstallDate: Year([DATE OF DELIVERY])
    Reply With Quote Reply With Quote
  6. Nov 8th, 2005, 05:15 AM #5
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: [RESOLVED] How to format to Just Year in MS Access

    If your field name have spaces then it's a rule to enclose them in brackets...

    Glad it worked.
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width