I am using the query builder to try and get an integer from a string field.
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?