change date to display datetime

vasilis6669

Hi,

How can i change the "order date" in Orders forms to display date in datetime format?
i.e 14/01/09 to be 14/01/09 16:45

Thanks,
Vasilis

garak

create a new field like "Order Date Time" in the sales header (so we don't modify the original field, so we have no trouble with some functions or updates).


In Order Date - OnValidate() in the table you write following:

.....
//New Code ++++++
if ("Order Date" <> 0D) then
  "Order Date Time" := CREATEDATETIME("Order Date",time); //time is the current systemtime
  //or u use
  //"Order Date Time" := CURRENTDATETIME; //it's the current system datetime
//New Code -------

Regards

vasilis6669

Yes,

That's a way to do it.

I can view the time only with this format 01/01/1754 12:15:00

Thanks,
Vasilis