Recent date format problem

[rblack]

hello there,

i try to get the recent date and i use the following lines:

Code: Select all

VBSTART
VBEND
Vbeval>DateAdd("d",-3,Date),someday
Vbeval>Year("%someday%"),yearw
Vbeval>Month("%someday%"),monthw
Vbeval>Day("%someday%"),dayw

and i want to input the whole recent date in a form, but it has to be in the file format YYYY-MM-DD , the following line:

Code: Select all

MessageModal>%yearw%-%monthw%-%dayw% 

for today displays: 2010-5-8 , and thats incorrect, i need to have 2010-05-08

in the Macro Sheduller 9 the following lines worked:
//and i cant paste the simple if lines, because the forum engine removes it
//here was a simple IF which added 0 when month or day was less than 10

but
MessageModal>%yearw%-%monthw%-%dayw% still returns the date in the format 2010-5-8 not 2010-05-08

Does anyone know how to solve that riddle?

[Marcus Tettmar]

You need to pad left with zeros:

VBSTART
VBEND
Vbeval>DateAdd("d",-3,Date),someday
Vbeval>Year("%someday%"),yearw
Vbeval>Right("00" & Month("%someday%"),2),monthw
Vbeval>Right("00" & Day("%someday%"),2),dayw

MessageModal>%yearw%-%monthw%-%dayw%

[rblack]

it works! didnt know that function! Thank you for super-fast and accurate reply!

[gdyvig]

If you don't do the padding Marcus recommends, this form of if statement works. I think you need to disable HTML in your post.

Code: Select all

IF>monthw<10
    Let>monthw=0%monthw%
endif
if>dayw<10
    Let>dayw=0%dayw%
endif

Gale

[rblack]

gdyvig: i used this solution, and it was workin in the older version of Macro Sheduller, but in the v11 it stopped working. Macrus solution works fine.