Search results for query: *

Hi @ll, Thx for your advise, I have build another formula in Excel that is usable in COGNOS using your idea... =CONCATENATE(ROUNDDOWN((AI26/3600),0),":",ROUNDDOWN((AI26-ROUNDDOWN((AI26/3600),0)*3600)/60,0),":",MOD(AI26,60)) regards, Ayato

Hello @ll, In Report Net, I have some processes running and automatically building and sending reports everynight with the performances of the previous day... Is it possible to insert a variable part in the name of the report when svaing it (like a string related to the date ?) e.g: all my...

Hello @ll, In Cognos report net, I need to format a amount of seconds to hh.mm.ss format. Any idea how to do that ? e.g: 120 = 00:02:00 regards, Ayato

HO HO HO PROBLEM SOLVED !!!!! THX to Nikki you saved me again :)) regards from the Netherlands Ayato

HO HO HO PROBLEM SOLVED !!!!! THX to Nikki you saved me again :)) regards from the Netherlands Ayato

Yes of course no difference at all !!! Btw, the date is a formula, TODAY()-1, but I have tried to paste values in macro before saving to csv (no result) Is possible that the regional settings of the machine are involved ? regards, Ayato

Hello both, Basically that's what I am doing, the structure is in fact a bit more complex. I have 3 files: 1 databook (main file), 1 template (yymmdd.xls) and 1 refresh file. I use the refresh file that will open databook and close it, then open the template file which contains only links to...

Hello, I have an excel file with date (yymmdd) and I use a macro to save xls to csv, something like : ActiveWorkbook.SaveAs Filename:="C:\test.200", FileFormat:=xlCSV, CreateBackup:=False When I run the macro, the format of the dates in the csv are changing to "yyyymmdd&quot...

Hello @ll, I have an excel file with a date using the format yymmdd, when I save this file to .csv my date is now yyyymmdd How can keep the same date format when saving to .csv? Please advise, Thx Ayato

Hi Nikki, Thx it works now ... One small problem left with the 1 line, which is a comment, I still have those commas ... It looks like : REPORT_TYPE=DAILY VERSION1.0,,,,,,,,,,,,,,, Any idea ? Regards, Ayato

Hello, I have a databook saving itself to CSV, the databook is only 5 lines of datas. When I open the CSV file I have a lot of comma everywhere even if there no values (cells are completely empty execpt for those 5 lines) It looks like this...