Date to Quarter and Year

building reports desktopintelligence
1

I have a date field that I would like to format into quaters and years… how can this be done?

pAUL

PaulR (BOB member since 2006-07-18)

2

Hi,

There are more functions in DeskI that you can use:
FormatDate()
Year()

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks for this, I know you can do dd/mm/yyyy etc… but how is quarters done?

Paul

PaulR (BOB member since 2006-07-18)

4

Hi,

To get the quarter number, use Quarter() function.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

many thanks… by I want to see if I can get q\yyyy format

PaulR (BOB member since 2006-07-18)

6

Hi,

I don’t think that there is a format for getting a quarter number from a date directly using only FormatDate() function. But I may be wrong though.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

7

ok thanks again…

PaulR (BOB member since 2006-07-18)

8

Maybe someone can answer this… So formatdate() does not support/retrieve quarters? In functions, Quarter() is only way to get quarters?

chander165 :us: (BOB member since 2005-12-20)

9

will the following give you the result you require:

=Quarter([Date]) + “/” + FormatDate([Date]; “yyyy”)

Malcolm (BOB member since 2005-03-09)

10

Hi, to add to this . . .

Can I change the quarter calc from Calendar quarter to Financial quarter?

i.e I’d like 02/02/2011 to be 2010Q4 rather than 2011Q1.

Surely this should be simple!

Thanks in advance.

geeklove (BOB member since 2006-07-05)

11

I don’t know of an off the shelf solution but try something like:

= FormatDate( ,“yyyy”) + “FQ” +
If Quarter() = 1 Then 3 Else If Quarter() = 2 Then 4
etc etc

I recommend that you use ‘FQ’ rather than just a ‘Q’ to identify that its a Financial Quarter not a standard one.

Malcolm (BOB member since 2005-03-09)