Hey people!

So basically:

1. I have created a custom field in the order system table (DateforOrder)
2. The value is stored from user filling in form at the shoppingpayment.ascx
3. The field is being saved in to Order Table (as a custom fields)
4. Now I want to get the value of the field into the invoice email template.
I have tried {%Order.DateforOrder%}
And have now attempted to use a custom macro to get the data from the field.

Here is my code:
case "dateorder":

int orderID = Convert.ToInt32(Request.QueryString["OrderId"]);
OrderInfo order = OrderInfoProvider.GetOrderInfo(orderID);

string hello = order.GetValue("DateforOrder").ToString();

result = hello;


break;
Still no result, and I have tried searching the forums and found nothing but the reference to custom macros(Appendix A) which is how I got the above but it is still not working. Please help me, as I have spent all day trying to do this !