frens,
source is .txt file
i have two columns ,
column1 has data -20170331 (yyyymmdd)
column2 has data -31052008 (ddmmyyyy)
my requirement is to calculate remaining days by subtracting column1-column2
to get it done i have coverted those column valeus to date and i have subtracted it ,
and my output column is numeric where these subtracted values has to be stored,
but when i tried to calculate days am getting values as o(zero)
below is the conversions used.
OCONV(iconv(20170331,"D YMD[4,2,2]"),"D-DMY[2,A3,4]")
-
OCONV(iconv(31052008,"D DMY[2,2,4]"),"D-DMY[2,A3,4]")
Please tell how to proceed with this.
Rgds,
Sriks
Regarding conversions
Moderators: chulett, rschirm, roy
is there any other way to do this?chulett wrote:You subtract the internal values to get the number of days between, so ditch the OConv otherwise you're just 'subtracting' two strings. ...
if so please let me know...
i have stored those two columns in other file by converting it to date and i used those columns which contains date to calculate days by subtracting those..but still i got the same result 0(zero)..but not the expected one..
thanks in advance
sriks