September 23rd, 2010, 08: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, 01: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.
It is a truism of American politics that no man who can win an election deserves to. --Trevanian, from the novel Shibumi
November 20th, 2010, 12: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.