Date

[rdlccn70]

Hello,

I would like the following date format "001.2016" divided in month and year. -> 001 and 2016 or 1 and 2016

Name of the dimension is DATAEGV_PERIODE

The data comes in this form:

001.2016

002.2016

.....

012.2016

Does anyone have this idea?

Thanks in advance.

Erdal

[rdlccn70]

Hi,

many thaks,

i have solved with:

Date#(left(right(DATAEGV_PERIODE,7),2),'MM') as Monat,

Date#(right(DATAEGV_PERIODE,4),'YYYY') as Jahr

Regards,

Erdal

Von: swuehl

Gesendet: Mittwoch, 10. Februar 2016 20:46

An: Cücen, Erdal, NMM-FF <Erdal.Cuecen@S4M.COM>

Betreff: Re: - Date

[rdlccn70]

Hi,

many thanks,

i have solved with:

Date#(left(right(DATAEGV_PERIODE,7),2),'MM') as Monat,

Date#(right(DATAEGV_PERIODE,4),'YYYY') as Jahr

Regards,

Erdal

[rdlccn70]

Hi,

many thaks,

i have solved with:

Date#(left(right(DATAEGV_PERIODE,7),2),'MM') as Monat,

Date#(right(DATAEGV_PERIODE,4),'YYYY') as Jahr

Regards,

Erdal

Von: Lokeshwari N

Gesendet: Donnerstag, 11. Februar 2016 09:45

An: Cücen, Erdal, NMM-FF <Erdal.Cuecen@S4M.COM>

Betreff: Re: - Date

[#5]

LOAD
  (mid(DATAEGV_PERIODE,5,4)) as Year,
 
  (mid(DATAEGV_PERIODE,1,3)) as Month

  FROM
Table

[swuehl]

Erdal Cücen wrote:

Hi,

many thaks,

i have solved with:

Date#(left(right(DATAEGV_PERIODE,7),2),'MM') as Monat,

Date#(right(DATAEGV_PERIODE,4),'YYYY') as Jahr

If you do it like this, you won't get your year and month parsed in correctly (i.e. you will get values with an underlying numeric value based on a date, not on the commonly used month numbers 1-12 or years.

Maybe you won't notice any issues untill you try to make e.g. selections or numeric comparisons.

If you don't know what I am talking about, create a list box for Jahr field with an Expression

=num(Jahr)