Forum

Hello, colleagues!
I have a problem with date separation. I need to extract the day of month from a string like that 7/6/2012. The problem is that sometimes month and day is of 2 digits and sometimes is of 1. Is there any standard function to split a string by a separator?

Hi!
Try something like this:

DateStr = "7/6/2012"
Str1 = Mid(DateStr, Find(DateStr, "/") + 1);
Day = Mid(Str1, 1, Find(Str1, "/") - 1);

Good, good, good, thanks!

Hello!
I like more this way:

   DateStr = "7/6/2012";
   DateStr = StrReplace(DateStr,"/",Chars.LF);
   Day     = StrGetLine(DateStr,1);
   Month   = StrGetLine(DateStr,2);
   Year    = StrGetLine(DateStr,3);