Results 1 to 3 of 3
  1. 07-10-2013, 03:55 PM #1
    edieb
    edieb is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2013
    Posts
    5

    New fiscal year dates

    How do you get the months to reflect new fiscal months, having July be month number 1 and June of the next year be month number 12?
    Reply With Quote Reply With Quote
  2. 07-10-2013, 05:19 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,952
    One method:

    Choose(Month(Date()), 7, 8, 9, 10, 11, 12, 1, 2, 3, 4, 5, 6)
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 05-13-2014, 08:42 AM #3
    aellistechsupport
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Apr 2014
    Posts
    410
    Check out this:
    https://www.accessforums.net/program...ear-43686.html
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Fiscal Year Tables and Relationships
    By Dorothy in forum Database Design
    Replies: 2
    Last Post: 07-19-2012, 08:52 AM
  2. Convert time stamp Now() to Fiscal Year
    By ajcke in forum Queries
    Replies: 17
    Last Post: 05-17-2012, 12:51 PM
  3. Fiscal Year in Access 2007
    By blindhawkeye in forum Access
    Replies: 1
    Last Post: 08-16-2011, 02:38 PM
  4. July-June Fiscal Year, Not Jan-Dec
    By blazerboy6 in forum Access
    Replies: 2
    Last Post: 04-14-2011, 02:23 PM
  5. fiscal year
    By RedGoneWILD in forum Programming
    Replies: 4
    Last Post: 08-04-2010, 01:38 PM

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

Other Forums: Microsoft Office Forums