Query by date range

Question

I have a feature class containing a text field which has the date a feaure was added and the user.  The format is "yyyymmdd-UserName".  What I would like to be able to do is select features based on a date range using VBA.  Any help will be much appreciated it.
 
Thank you,
Leonel

IngridHogle · Answer

I have this exact same situation and need, using SQL Server Express. Were you able to find a way to do what you described here?

LeonelTorres · Answer

Thanks for your help.  I will have to find out how to do it in SQL Server.

AlexanderGray · Answer

In that case the syntax will be tricky. You will need to see which string functions apply to your database's SQL. for featureclasses in oracle you can use INSTR to find the position of the dash, SUBSTR to get only the part before the dash, TO_DATE to convert it to date and finally you can do '<', '>' operations with the dates in the where clause. it works out to something similar to this in Oracle where = "TO_DATE( SUBSTR(DateUserField,1, INSTR(DateUserField, '-') -1), 'YYYYMMDD') < TO_DATE('23-06-2011', 'DD-MM-YYYY') AND TO_DATE( SUBSTR(DateUserField, INSTR(DateUserField, 1, '-') -1), 'YYYYMMDD') > TO_DATE('22-06-2011', 'DD-MM-YYYY')" For file geodatabase or shapefile, I don't know if you can do the string functions.