I have a column called datedx which is defined as varchar8, and the format is yyyymmdd.
If the length is 8, then it is ok. There are 3 possibilities in this field:
1. If it is yyyymmdd, then it is ok.
2. If it is yyyymm, then I would like the result to be yyyymm + 15.
3. If it is yyyy, then I would like the result to be yyyy+0715.
Please help me to write this into a script.
Thank you for your help.
View Complete Post