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'
Converting from string to date
Moderators: chulett, rschirm, roy
Converting from string to date
this is nice
-
- Participant
- Posts: 4
- Joined: Wed Oct 27, 2010 2:22 am