Changing string-values to date-values

[Jürgen Dietze]

Infopath2007

Good morning,
i have the following problem:

From a secondary-dataconnection i get string-values in this way: "17.02.2009"

Now i use a primary-datafield of the type "date" and want to set the value
of the secondary-datasource.

So far, so good.

When i try to publish the form to a sharepointlist an error occures, saying
that there is an uncorrect value.

What can I do, to change the type of this value? I want to sort the column
of the sharepointlist by date!

Hope you understand my problem and you can help me
Jürgen Dietze

 

[Jürgen Dietze]

Hi everyone,
i solved the problem:

Using the functions concat and substring i resolved my string-date and
joined it gain like this:

Textvalue: "10.02.2009"
Date:
concat(substring(Textvalue, 7,
4),"-";substring(Textvalue;4,2),"-",substring(Textvalue,1,2))

That's it!