Making a calculation based on the result of a drop down list

FM8.5
In my INVOICE table I have a Custom value list;

Terms
5
15
30
60
consignment

I would like to create a calculation wherein the Due Date & Overdue
Field is determined in part by the result of the Terms selection. I
want an 'at a glance' indication of days overdue.

For example, now my Field Due_Date (calc) = DateShipped + 30
But I would like it to be Date_Due = DateShipped + (the number stated
by Terms). But I do not know how to write this expression.

Thanks
M

Re: Making a calculation based on the result of a drop down list

Buck,

Did you even try? because the example you gave is completely acurate.

Dates are stored as numbers and you work with them as numbers, then display
them as dates.

So

cDueDate ( calc ; date) = DateShipped + Terms

should do it

Keep well, Ursus

schreef in bericht
news:25311432-1501-4249-a1cb-454934fd3f43@e10g2000prf.google groups.com...
> FM8.5
> In my INVOICE table I have a Custom value list;
>
> Terms
> 5
> 15
> 30
> 60
> consignment
>
> I would like to create a calculation wherein the Due Date & Overdue
> Field is determined in part by the result of the Terms selection. I
> want an 'at a glance' indication of days overdue.
>
> For example, now my Field Due_Date (calc) = DateShipped + 30
> But I would like it to be Date_Due = DateShipped + (the number stated
> by Terms). But I do not know how to write this expression.
>
> Thanks
> M
>

Re: Making a calculation based on the result of a drop down list

Ha ha ha

No I didn't, now I have. How mistakenly presumptuous I was.

Thank you


On Jan 7, 8:12=A0am, "Ursus" wrote:
> Buck,
>
> Did you even try? because the example you gave is completely acurate.
>
> Dates are stored as numbers and you work with them as numbers, then displa=
y
> them as dates.
>
> So
>
> cDueDate ( calc ; date) =3D DateShipped + Terms
>
> should do it
>
> Keep well, Ursus
>
> schreef in berichtnews:25311432-1501-4249-a1cb-=
454934fd3f43@e10g2000prf.googlegroups.com...
>
> > FM8.5
> > In my INVOICE table I have a Custom value list;
>
> > Terms
> > 5
> > 15
> > 30
> > 60
> > consignment
>
> > I would like to create a calculation wherein the Due Date & Overdue
> > Field is determined in part by the result of the Terms selection. I
> > want an 'at a glance' indication of days overdue.
>
> > For example, now my Field Due_Date (calc) =3D DateShipped + 30
> > But I would like it to be Date_Due =3D DateShipped + (the number stated
> > by Terms). But I do not know how to write this expression.
>
> > Thanks
> > M