Dae format

DesmedtS
DesmedtS Member Posts: 53
edited 2002-01-14 in Navision Financials
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" />

Comments

  • john.fo
    john.fo Member Posts: 16
    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.

Categories