C/Front and DateFormula

guidorobben

Hi,

I have a problem to write to a DateFormula Field From Excel.

AssignField(QueueT, EntryR, 2, "+3D")

I get the following error:
'+3D' is too big for the internal variable 'DateFormula'

I also tried:

AssignField(QueueT, EntryR, 2, "<+3D>")

If I skip this field, the record gets inserted, so the rest of the process works fine.

Doe anybody know how to solve this problem?

Thanks

bvbeek

guidorobben wrote:

Hi,

I have a problem to write to a DateFormula Field From Excel.

AssignField(QueueT, EntryR, 2, "+3D")

I get the following error:
'+3D' is too big for the internal variable 'DateFormula'

I also tried:

AssignField(QueueT, EntryR, 2, "<+3D>")

If I skip this field, the record gets inserted, so the rest of the process works fine.

Doe anybody know how to solve this problem?

Thanks

Please try this:

OLD: AssignField(QueueT, EntryR, 2, "<+3D>")
NEW: AssignField(QueueT, EntryR, 2, '+3D')

Let me know!

guidorobben

Didn't work. Excel doesn't like the '

Any more ideas?

ufuk

Are you trying to write to Excel or read from excel? Can you explain more?

guidorobben

I want to write a value from excel to a Navision-DB

ufuk

Are you trying to calculate a newdate based on an Excel date field with a date formula expression in Navision?

I have tested reading a date from Excel and use calcdate to generate a new date. I had no problem in the code below:

Text001 := '+3D';
IF EVALUATE(VarDate,FORMAT(XlSheet.Range('A' + FORMAT(i)).Value)) THEN
  NewDate := CALCDATE(Text001,VarDate);

guidorobben

I'm trying to write a value from excel to the database. I get a C/Front error saying that it cannot handle the value

AssignField(QueueT, EntryR, 2, "+3D")

I get the following error:

'+3D' is too big for the internal variable 'DateFormula'

I want to write +3D to a Navision DatFormula Field using C/Front.

ufuk

I do not have enough experience in C/Front. I think it must be something related with the syntax. Have you tried using only one ' with your expression. Something like '+3D or "'+3D", " ' " + "+3D" etc. I am only guessing

Or isn't it possible to get data by C/Side?