If you only want it to appear once at the top of the report, place an Unbound Value Box in the Report Header. Assuming it is named LE1, program it as follows:

LE1 = @Date

You can also use the program to show a more complex value:

LE1 = "Report As Of : " + @Str(@Date)

Or to format the date as needed.

Quote:


@Date will always return the date in the internal format of YYYY/MM/DD. If you want DD/MM/YYYY, format it in code. Something like this:

LE1 = @Str(@Dom(vValue)) + "/" + @Str(@Month(vValue)) + "/" + @Str(@Year(vValue))

I'm not sure precisely what you are trying to do, but, if you need to use @Date then:

LE1 = @Str(@Dom(@Date)) + "/" + @Str(@Month(@Date)) + "/" + @Str(@Year(@Date))

This will get you today's date:
LE1 = @Str(@Dom(@Date)) + "/" + @Str(@Month(@Date)) + "/" + @Str(@Year(@Date))

If you need some other date, let me know.

Yes, that is possible, but you will need to have an external batch file actually control the timing of when Sesame runs. Write the SBasic program that actually does the date check and the email - probably use one of the variations on XLookup to check the date. Put the SBasic program in the application open event of an otherwise nearly empty application. Use the macro recorder to record and save a macro that exits Sesame.

Then use a batch file / shell script to start Sesame on a schedule (i.e.: once a minute, once an hour, etc...) Use the "-macro" startup flag to start the macro running. When started, Sesame will run the SBasic program that checks the date value and possibly send the email. Given sufficient "wait", the macro will then cause Sesame to exit. The batch file will then wait for the specified period and then do it again, ad infinitum.

In this way you can use Sesame as a "batch" processor that requires no human intervention.