Need help with the date script

timle · Post by **timle** » Thu Dec 06, 2007 4:33 am

Day>today
add>today,1
Let>tomorrow=today+1
message>tomorrow is the %tomorrow%

When I run this script, it convert the date to one digit. How could I keep the date to display 2 digits "07"

thank you

Post by **Marcus Tettmar** » Thu Dec 06, 2007 8:48 am

The mathematical operation is converting the value to a number. If you want prefixed zeros you need to format it as a string again. This will do what you want:

Code: Select all

VBSTART
VBEND

Day>today
add>today,1
Let>tomorrow=today+1

VBEval>Right("0" & "%tomorrow%",2),tomorrow

message>tomorrow is the %tomorrow%

See the VBEval line which uses the Right function. We add a 0 to the left of the value and then take only the last two digits. So if tomorrow was 10 or more, we'd still end up with only two digits without the prefixed zero.