In order to use in qw ,
I must convert number field into date format
I get data from oracle db number format is : YYYYWW and also date format should be YYYYWW
to_date(to_char(ORIGIN_YEAR_WEEK),'YYYYWW') sql auery does not work
Just use function
or you can also try
Ii did not work
MakeWeekDate(YYYY [ , WW [ , D ] ] )
in your LOAD or an expression.
Hope this helps,
ORIGIN_YEAR_WEEK column' s data are like this 201201,201202
swuehl it didnt work in expression I will try in load statement
returns 09/01/2012 when used as expression in a textbox, seems ok to me.
Retrieving data ...