Extract Month from date element in calc element

[venekamp]

Hi,

I have a date element. Now I need also a seperate field that only contains the month (01---12) of that date element. I have been looking for hours now, but I cannot find te right solution. I tried the calc-element, using PHP functions. Please help.

 

[lousyfool]

Use '{table___date_raw}' and then date_format: https://www.w3schools.com/php/func_date_date_format.asp

 

[venekamp]

Me dombo. I overlooked the "_raw" suffix.
Thanks it works fine in the calc element with

$date= date_create('{fluve_fltuin_quicklog___datum_raw}');
return date_format($date,"n");
Giving the month number I need.