Explain the syntax?

[#1]

Hi,

Can you plz explain this below syntax.

if my date is 12/02/2014 then what will happen using this below syntax.

right(repeat(0,1)&subfield(date(date),'/',1),2)

[ashfaq_haseeb]

12

If it is 5/02/2014 it will return 05

Regards

ASHFAQ

[alexandros17]

right(repeat(0,1)&subfield(date(date),'/',1),2)

Transform date to a date format -> date(date)

Then with subfield take the first part of the date : if 7/06/2014 it takes 7

The repeat repeat the char 0 1 time so you have a string 0 concatenated to 7

at the ent it takes only the 2 char to the right

[#4]

Hi Ashfaq,

What is the use of repeat(0,1) here?

[ashfaq_haseeb · Accepted solution]

I just explained.

If you date is 5/02/2014.

It will add leading zero. Here o/p will be 05.

Regards

ASHFAQ