Hi,
I need to convert a date from an SQL table datetime to an ascii numeric MMDDYY field.
When I run the query I reformat the date to read as MMDDYY by removing the separators and assigning the correct output form. My problem is I get a result that catches the space where the separator would be thus making the data 8 chr long instead of the required 6.
Can anyone help me with this task?
thanks,
stan
Remember - only dead fish go with the flow.
I need to convert a date from an SQL table datetime to an ascii numeric MMDDYY field.
When I run the query I reformat the date to read as MMDDYY by removing the separators and assigning the correct output form. My problem is I get a result that catches the space where the separator would be thus making the data 8 chr long instead of the required 6.
Can anyone help me with this task?
thanks,
stan
Remember - only dead fish go with the flow.