on 04-26-2007 6:24 PM
Post Author: tripus
CA Forum: Formula
I want to show Numberic datatype colomn in database as a Date_type format in report header, For example
Data in Database I want to show in Report heading as
200412 December, 2004
200506 June, 2005
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Yangster. The formula is working fine.
Post Author: yangster
stringvar year_string := totext(field)[1 to 4];stringvar month_string := monthname(tonumber(totext(field)[5 to 6]));month_string&", "&year_string
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.