September 23rd, 2010, 09:25 PM
How to convert a search a string field that represents a date
I have a company from Italy that has used a string field for a date field and it's in the format of yy/mm/dd hh:mm:ss. So, 9-23-10 at 7:19PM at 23 seconds looks like:
How can I convert and this string field based on a date to and from request:
8/19/10 01:00:00 to 8/30/10 23:59:59
September 24th, 2010, 02:27 AM
I don't quite understand what you're asking, but there are vbscript functions that may help. Check out the formatdatetime() and cdate() and cstr() functions.
I've never been able to appreciate the sublime arrogance of folks who feel they were put on earth just to save other folks from themselves .." - Donald Hamilton
November 20th, 2010, 01:13 PM
you'll want to use the datepart function explained here:
Originally Posted by JackDWeb
w3schools .com/ vbscript/ func_datepart.asp
to parse out the pieces and then assign each to a variable so they can be reassembled as a string with the desired sequence.