How possible can i segment Date in format MM.DD.YYYY into Day, Week, Month, Quarter, Half Yr & Yearly

[Anonymous]

Hello Peeps,

Find attached explain better.

Rgds

[#2]

Hi,

You can use Date and Time functions.

You can say: Year(Date), Month(Date), Week(Date), Day(Date).

Thanks,

Sai

[ecolomer · Accepted solution]

Her you are

[ecolomer]

I'm sorry ... is spanish

Dia = Day

Mes = Month

Semana = Week

Año = Year

I attach new file QV

if you need anythink else tell me

In the QV is necessary to put

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY h:mm:ss[.fff] TT';