InfoPath Dev

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.

Hi Lenovo27,

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

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

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))