Skip to Content
0
Former Member
May 13, 2010 at 05:08 PM

number field to date

30 Views

i am using the following so i can sort the dates properly.

i receive BAD NUMBER FORMAT STRING

stringvar year1;stringvar month1;stringvar day1; stringvar yyyyMMdd;

year1:= totext({USR_CR_BENE_ACT;1.BookDate},"yyyy");

month1:=totext({USR_CR_BENE_ACT;1.BookDate},"MM");

day1:=totext({USR_CR_BENE_ACT;1.BookDate},"dd");

yyyyMMdd:=month1&day1 & year1;

yyyyMMdd;

Is there another formula i can use to sort dates correctly