Date time formats

Jul 8, 2011 at 11:05 AM


Thanks for creating this solution - its exactly what we needed but I have a couple of questions:

Is there any way of changing the format of the Approval Date column to only display date? I noticed that it is defined as a single line of text - is it possible to set this to be a date/time column and use the properties to only display the date part?

Also is there a way of displaying date using other formats - ie instead of 08/3/11 say 08 March 2011 ??



Jul 11, 2011 at 11:49 AM

Replying to my own post here but.....

.... I changed the properties of the Approval Date column to be a date/time and only display the date. This appears to work but unfortunately the dates are somehow translated into US date format, although my servers and client are all configured to use UK time format.  so for today (11 July 2011) the approval column shows 11/07/2011 (11th Nov 2011)!!

Help! Had to stop using this now :-(