Identifier could not be found

[Lantis]

Hi, I'm pretty new to all this and this is the first time I look for help myself. I have a simple problem. I have two tables:

1. one table has a number field for each item.
2. the other field has a date/time field that is calculated using a macro

This macro I am using should do this at the end:

SetField
Name: Order.Total
Value = FormatDateTime(Now()+[Records].[RecordCount],2)

Every time I try to do this, it gives me an error message saying: "The identifier '[Records].[RecordCount]' could not be found. But the field IS there!!!

Thanks for any help.

Lantis

[Robeen]

It looks like the syntax of your FormatDateTime() function is incorrect?
Check this thread [on another site] - it has some examples:
http://www.pcreview.co.uk/forums/for...-t3949570.html
Let me know if you need any more help.

[Lantis]

Hi, I had a look at the examples, but I am afraid I'm not that savvy to understand them completely. Could you please tell me how would you write that syntax? Thx.

[Robeen]

Can you explain with a little more detail what exactly you need to achieve?
When I first looked at your post, I was only focusing on the syntax of your FormatDateTime() function.

[Lantis]

This macro is a part of Before Update of a table so when I enter a record and then go to a new record it should automatically set the [Total] field to a certain date (now + the value in the field [RecordCount] (that is usually 2).