procedure Memo1OnAfterData(Sender: TfrxComponent);
begin
    Memo1.Text := FormatDateTime('d',SqlDateTimeToDateTime(<Report."Date">)) + ' ' 
      + FormatDateTime('mmmm',SqlDateTimeToDateTime(<Report."Date">)) + ' '
      + FormatDateTime('yyyy',SqlDateTimeToDateTime(<Report."Date">));  
end;

Using Derek's example see attached for another option. I'm not in no way trying to say that my way is the best. Just trying to show another possiblity.

@Asifmute: i would advise to follow Derek's solution, using a calculated field is (in my opinion) much easier to maintain, oversee, and plan in your application. Debugging is much faster, and doesn't (really) break any other code if you would make small adjustments here and there, if it does then a calculated field is quickly adjusted.

I also tried to make a solution based on a report sql query by concatenating (which i learned from Derek) using '||' between the fields, have a look as attached.

SELECT  
STRFTIME('%d', date)    
||
case strftime('%m', date) when '01' then ' January ' when '02' then ' February ' when '03' then ' March ' when '04' then ' April ' when '05' then ' May ' when '06' then ' June ' when '07' then ' July ' when '08' then ' August ' when '09' then ' September ' when '10' then ' October ' when '11' then ' November ' when '12' then ' December ' else '' end
||
STRFTIME('%Y', date)
FROM dates
WHERE dates.id = $id;  

Attached is a quick sample.

so you want to show the name of the month?

try in your report SQL:

SELECT
 case strftime('%m', DateTimerPickerField) when '01' then 'January' when '02' then 'Febuary' when '03' then 'March' when '04' then 'April' when '05' then 'May' when '06' then 'June' when '07' then 'July' when '08' then 'August' when '09' then 'September' when '10' then 'October' when '11' then 'November' when '12' then 'December' else '' end
as month 
  FROM table;

to make it a bit clearer:

I am creating a report by report sql - Button.

I need the Datetimepicker Date formatted as MMMM to be passed to the Report.

Any Idea ??

is it a wrong date or is it incorrectly formatted? do you have a screenshot?

i'm stuck on how to pass the datetimepicker value to the report. Using the Variables Datetimepicker in the report gives me a totally wrong date!

Could someone please help me out ...

Thank you

Lupo