General

Re: Custom date format?

Jimmy — Wed, 10 Aug 2011 19:51:40 GMT

You can use an expression box (calculated value in 2010) with this XPath:

concat(substring(dateField, 6, 2), '.', substring(dateField, 9, 2), '.', substring(dateField, 1, 4))

Re: Custom date format?

Erich — Tue, 09 Aug 2011 17:19:35 GMT

Use the following code in javascript :

var zeros = ["01","02","03","04","05","06","07","08","09","10","11","12"];

var oDate = new Date();
date = odate.getDate();
if(date < 10) date = zeros[date-1];

strDate = zeros[odate.getMonth()] + "." + date + "." + odate.getFullYear();

The zeros array is used so a zero is appended before any single digit.

Erich

Re: Custom date format?

Patrick Halstead — Mon, 08 Aug 2011 05:35:27 GMT

Hi Lenovo27,

Not sure if you can use 3rd party plugins or not, but qRules has a very powerful FormatDate feature.

Custom date format?

lenovo27 — Tue, 02 Aug 2011 16:35:40 GMT

Anyone know how I can setup a custom date format? I need the field to show the date in the following format: 08.02.2011

I believe I can use xpath for this though I am not quite sure how to write it out.