Converting from string to date

[skyboyfli]

I have a field like in this format 23-jul-09

I tried convert it into date as
StringToDate(Ln_Sq.Field05,"%dd-%mmm-%yy")

StringToDate(Ln_Sq.Field05,"%dd-%mon-%yy")


But both there are not working, i am getting warning like this:
'Data string ' 26-JUN-1' does not match format '%dd-%mmm-%yy': an integer was expected to match tag %dd.'

Can anybody tell em the structure of the function to get the format 'YYYY-MM-DD'

[ajith_infy]

Apply Trim function on string before converting to date

[skyboyfli]

Apply Trim function on string before converting to date

I did not get you...

which one to be trimmed in the string...
it is not having any unnecessary chars to trim

[ArndW]

Your data string error message shows a leading space, which, as ajith_infy has already seen, needs to be removed in order for the format to match.

[skyboyfli]

Apply Trim function on string before converting to date

Thanks ajith....
i got it.