How to cancatenate date formula

roshini

Hi Nav Experts!

How to concatenate field +M

Example: '1M'

paymentdate is a field in customer table.

I want to use the formula '1M' like my filed(paymentdate)+M, how to write code?

My code as follows:

dategrace:= paymentdate;

date1:='dategrace+M'

payment2:= CALCDATE(date1, MonthStartDate);


but it is throwing error.

garak

Try this.

Name	DataType	Subtype	Length
NewDate	Date		
BaseDate	Date		

BaseDate := 12072008D;
NewDate := calcdate('<1M>',BaseDate);
message(format(NewDate));

Regards

pri_1_ranjan

I hope dategrace and date 1 have datetype as 'text' ; and paymentdate as integer. MonthStartDate and Payment2 as Date.

you could use following code snippet might help, if it suits u

dategrace:= format(paymentdate);

date1:=dategrace+'M'

payment2:= CALCDATE(date1, MonthStartDate);

hope this helps

David_Singleton

garak wrote:

Try this.

Name	DataType	Subtype	Length
NewDate	Date		
BaseDate	Date		

BaseDate := 12072008D;
NewDate := calcdate('<1M>',BaseDate);
message(format(NewDate));

Regards

Maybe I am missing something, but I can not see how this in any way addresses the question asked?

David_Singleton

roshini wrote:

Hi Nav Experts!

How to concatenate field +M

Example: '1M'

paymentdate is a field in customer table.

I want to use the formula '1M' like my filed(paymentdate)+M, how to write code?

My code as follows:

dategrace:= paymentdate;

date1:='dategrace+M'

payment2:= CALCDATE(date1, MonthStartDate);


but it is throwing error.

Although you some how "forgot" to tell us what the error was. I guess it is a type mismatch. The problem being here that you have three different variables types, Integer, Text and DateFormula. So you need to use the format and evaluate functions to solve this. I don't have time to try it out, bu somethign like :

OK := evaluate(MyNewFormula,strsubstno('%1M',DaysOfGrace));

ara3n

here is an example on tips and tricks

viewtopic.php?f=5&t=13982

garak

Because i understand it so, that he will calculate the payment2 date based on payment date field + 1 Month based on the 1. of the currmonth.

Or need he a concatonation of dateformulas?

Regards

roshini

Thanks a lot for the suggestions! I got much idea about date formula use.

Great!!

My purpose solved with the solutions of Mr.David Singleton/Mr. pri_1_ranjan.

I struggled to get that value,Thanks a lot.....