Hi Srinivasa Prabhu,
Try the following formula;
datevar x;
stringvar y;
x:=date({Orders.Ship Date});
if length(totext(time({Orders.Ship Date}))) = 10
Then y:=left(totext(time({Orders.Ship Date})),5)
else Y:=left(totext(time({Orders.Ship Date})),4);
x&' '&y;
Regards,
Sastry
Add a comment