BUG(?): date_str_custom with format "F" not delivering what's expected

kludikovsky

Issue:

I am using the 

date_str_custom(Datum,"F") 

to get the weekday from an attribute into a new attribute. According to https://docs.rapidminer.com/latest/studio/operators/blending/attributes/types/nominal_to_date.html 

 

I am not sure what it delivers but it's definitely not the weekday. 

It looks like the week in the month.

It seems to be a bug.

 

 

For Testing I also used the  

date_str_custom(Datum,"E") 

 which did what's expected.

 

The attached scrrenshot shows the delilvered result.

 

 

The operator is (just copy & past into the canvas - no import)

 

<?xml version="1.0" encoding="UTF-8"?><process version="8.0.001">
  <operator activated="true" breakpoints="after" class="generate_attributes" compatibility="8.0.001" expanded="true" height="82" name="Generate Attributes" width="90" x="648" y="595">
    <list key="function_descriptions">
      <parameter key="Weekday" value="date_str_custom(Datum,&quot;F&quot;)"/>
      <parameter key="Week" value="date_str_custom(Datum,&quot;w&quot;)"/>
      <parameter key="Day" value="date_str_custom(Datum,&quot;E&quot;)"/>
    </list>
    <parameter key="keep_all" value="true"/>
  </operator>
</process>

 

Edin_Klapic

Hi @kludikovsky,

 

Thanks for letting us know! I have the same experience and will forward it internally.

As a workaround you could use the Operator Date to Numerical and set the parameter time unit to day and day relative to to week.

This should provide the desired result.

 

Best regards,

Edin

sgenzer