Hi you guys, long time no see !!
A little variation on another date problem.
I have a string variable representing a date. As we are now in January 2013, it creates a bigger problem than what I'm able to handle, I hope you can help me !!! A typical value in that variable appears like this :
But now, I have the following adding up to the database :
201315 (for January 5).
I have the following syntax :
And I need to...
Add a zero at position 5 and at position 7 if the string is only 6 characters long.
Add a zero at position 5 if the string is only 7 characters long AND well ... I'm not sure.
Would anyone be able to fix this thing?