Date issue in report designing

Hi,

I am preparing a report where a situation exists such as adding process with the date functions. Suppose I hav a posting date from a different data item. I need to perform an operation such as i need to add 5 days to the posting date in the variable created. Can anyone help me out with this. I am getting an error “Type conversion not possible - Date + Text” in my trial.

how you are adding 5D to Posting Date?

use

CALCDATE(’<+5D>’,“Posting Date”)

Can you write in a detail

hey thanks… its working…!!

welcome…

Please Don’t forget to VERIFY the post(s) that solved your problem.

ya sure… :slight_smile:

The issue is, its not giving any error now at the same time its not displaying any value also in the report…

I have used -
recSalesHeader.RESET;
recSalesHeader.SETRANGE(“No.”,“Export Order No.”);
IF recSalesHeader.FINDFIRST THEN
BEGIN
OrderDate := recSalesHeader.“Order Date”;
NewDate := CALCDATE(’<+7D>’,recSalesHeader.“Order Date”);
END;

For the variable OrderDate its giving the value but for NewDate its not displayin anythin…

Add Message(’%1’,NewDate); after calculation and check