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