kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
I am accepting date input as dd-mm-yy.
A user might enter 6-7-20.
In this case, I want to convert the input to 06-07-20.
I can do this with a few case statements and or if statements.
But I am having the feeling there could be a cleaner and shorter way to do it.
Can someone point it out for me?
Thanks
A user might enter 6-7-20.
In this case, I want to convert the input to 06-07-20.
I can do this with a few case statements and or if statements.
But I am having the feeling there could be a cleaner and shorter way to do it.
Can someone point it out for me?
Thanks