>I've got the following date: 01/11/1999
>
>Is there a function that I can apply to it that will give me as a result: {^1999-11-01} ?
>
>The reason is that I wan to construct an SQL filter and I dont want to have 01/11/1999 in my construct but {^1999-11-01}.

I am curious... why do you want to convert the date to a character in the filter, why not just leave it in a variable?

BOb