Results 1 to 2 of 2

Thread: formatting date

  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Unanswered: formatting date

    hi
    I have the following date 16/04/2013

    how do I format it to 1 6 0 4 2 0 1 3

  2. #2
    Join Date
    Nov 2013
    Posts
    4
    Hi..

    Use the below three formula

    {@f_dat}
    **********
    '16/04/2013'

    {@f_dat1}
    *********
    replace({@f_dat}, '/', '')

    {@f_res}
    *******
    stringvar temp;
    numbervar t;
    numbervar ind;
    t:= 1;
    ind:= len({@f_dat1});
    while(t <= ind)
    do
    (
    temp:= temp + mid({@f_dat1},t, 1)+ ' ';
    t:=t+1;
    );
    temp:=ltrim(rtrim(temp));


    Thanks,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •