Dae format

DesmedtS

---

Hello,

I used a date function :
STRSUBSTNO('%1',DATE2DMY(TODAY, 2))
So for example when it is the first of January, i get 1.
This is jsut my problem when the day is smaller than 10, the function always returns 1 digit. So in this case i have to get 01.
Of course I first can do a test IF value < 10 then
....;
But i Want it in 1 line. (Format function ?????)
Does somebody have a solution ?

Thx Steve
<img border="0" title="" alt="" src="images/smiles/icon_eek.gif" />

john.fo

Hi Steve.
You're right - you can use format like this:
format(TODAY,0,'<DAY,2>');
which will give you the day with 2 digits. Check out the help for format function - It's quite flexible.