As I said, drop m. prefix.

m.myvariable = "? DATETIME()"
&myvariable

>
>I had tried a number of combinations but all gave me an error.
>
>Regards
>Geoff
>
>>>I probably missed this somewhere because this discussion has got awfully long and maybe it's self defeating but :-
>>>

How do I do macro substitution with a m. variable?

>>
>>Geoff,
>>
>>You cannot use table field in the macro substitution so you can safely drop m. prefix.