Hi Everyone, I need to convert below crystal report formula in Jasper Studio. Please help. dim ary() as string, formatOK as boolean formatOK = true ary = split({?dte_book_dt}, "/") if ubound(ary) <> 3 then formatOK = false elseif not(isnumeric(ary(1)) and isnumeric(ary(2)) and isnumeric(ary(3))) then formatOK = false end if if formatOK = true then if {?dte_book_dt} = "" or isnull({?dte_book_dt}) then formula = "" else formula = totext(datevalue(tonumber(ary(3)),tonumber(ary(2)),tonumber(ary(1))),"dd-MMM-yyyy") end if else formula = "Date Format should be in DD/MM/YYYY" end if Thanks Navneet