Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
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
Best regards
Hi,
Just use function
-Dtae#(date_field)
or you can also try
-Date(date_field)
Ii did not work
ORIGIN_YEAR_WEEK column' s data are like this 201201,201202
swuehl it didnt work in expression I will try in load statement
=MakeWeekDate(left(201202,4),right(201202,2))
returns 09/01/2012 when used as expression in a textbox, seems ok to me.