I'm not sure if I understand your question...

Quarters of the year are always the same

Q1 Jan 1st to March 31st
Q2 Apr 1st to Jun 30
Q3 Jul 1st to Sep 30
Q4 Oct 1 to Dec 31st

Posted By: Vivid Data Shark on December 10th 2012 at 15:26:05

Message Thread

Can someone please help me to calculate quarterly dates? (NCFC) - Larry Hagman, Dec 10, 14:39:54
- It's all in GL.GL_PERIODS (n/m) (NCFC) - NorfolkSteve, Dec 10, 16:40:49
- Its something to do with EOMONTH function. (NCFC) - tudders, Dec 10, 16:11:53
- Late contender for Thread Of The Year (n/m) (NCFC) - Huge Small, Dec 10, 16:00:22
  - lol (n/m) (NCFC) - Tricky Hawes, Dec 10, 16:07:47
- is this what you mean? (NCFC) - greybeard, Dec 10, 15:40:54
  - Nope, quarterly from 27/01/2011 (n/m) (NCFC) - Larry Hagman, Dec 10, 15:45:00
    - Am I missing something? All the months have more than 27 days, so you just change the mon (NCFC) - Arizona Bay, Dec 10, 15:47:17
- I'm not sure if I understand your question... (NCFC) - Vivid Data Shark, Dec 10, 15:26:05
  - Quarterly starting from 27/01/2011 (n/m) (NCFC) - Larry Hagman, Dec 10, 15:44:35
- There is a way of doing this, give me a minute. (n/m) (NCFC) - tudders, Dec 10, 15:07:32
  - Cheers! (n/m) (NCFC) - Larry Hagman, Dec 10, 15:09:29
    - Might be more like an hour, late for a meeting. (n/m) (NCFC) - tudders, Dec 10, 15:15:46
      - OK (n/m) (NCFC) - Larry Hagman, Dec 10, 15:22:34
- At a guess it would be 31 Mar, 30 Jun, 30 Sep, 31 Dec.... (n/m) (NCFC) - Vivid Data Shark, Dec 10, 14:51:41
  - I need em all to be right from 27/01/2011 (n/m) (NCFC) - Larry Hagman, Dec 10, 14:54:40
- just add 3 months at a time and approximate thae date, No one will notice. (NCFC) - Cheltenham_Canary, Dec 10, 14:41:47
  - No, I need it to be right, Anyone have excel? (NCFC) - Larry Hagman, Dec 10, 14:46:52
    - that won't do it.... (NCFC) - Pixelman, Dec 10, 14:49:21

Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.