Todd MacPherson
asked on
Getting integer out of a string with leading zeros in query builder
I am using the query builder to try and get an integer from a string field.
CST: CInt([RF_STDTE])
Where the [RF_STDTE] is a string text of dates. I want to convert it to an integer in the query builder but not change the format of the field in the database table.
It was saved to the text field in the format YYYYMMDD
The MM and DD can have zero place holders so I think that is why it reports an error.
How can I do this?
Thanks
CST: CInt([RF_STDTE])
Where the [RF_STDTE] is a string text of dates. I want to convert it to an integer in the query builder but not change the format of the field in the database table.
It was saved to the text field in the format YYYYMMDD
The MM and DD can have zero place holders so I think that is why it reports an error.
How can I do this?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER