Hello,
I use BI4 and I would like to transform a chain of caracteres in a date format. The function, in the french version, is AlaDate.
=RéponseUtilisateur ([Requête 1 avec CIC] ; "Date de Début") is good but the respons is a chain Text.
=ALaDate( RéponseUtilisateur ([Requête 1 avec CIC] ; "Date de Début") ;"dd/MM/yyyy") is good when I verify with Webi-corrector but is wrong when I put this variable in the report.
Thanks for your help.
can you please translate in English? what is the format of date value in the first formula?
=RéponseUtilisateur ([Requête 1 avec CIC] ; "Date de Début")
=(UserResponse ([Requête 1 avec CIC] ; "Date de Début"))
CIC is the universe
"Date de Début" is the demand in the prompt
if you will drag the formula =(UserResponse ([Requête 1 avec CIC] ; "Date de Début")) in report block then what is the format of date.
e.g like 14/11/2017 or with time stamp.
In english is :
=ToDate(UserResponse ([Requête 1 avec CIC] ; "Date de Début");"DD/MM/YYYY")
Webi says "The formula is defined correctly".
If I use =(UserResponse ([Requête 1 avec CIC] ; "Date de Début")), I have 14/11/2017 00:00:00
I write really
=Replace((UserResponse ([Requête 1 avec CIC] ; "Date de Fin")) ; "00:00:00" ;"")
to have 14/11/2017 but the problem of the ToDate si the same
Todate function is depend on the date format of userresponse.
let say with user response if you are getting values like 14/11/2017 then todate formula will be correct if you put "dd/MM/yyyy".
If with user response you are getting values like 14/11/2017 09:01:10 then correct value is "dd/MM/yyyy hh:mm:ss"
Formula will be validated but you will get the #error message in the report.if still you have doubt then share how is the value coming in userresponse.
try this.
=ALaDate( RéponseUtilisateur ([Requête 1 avec CIC] ; "Date de Début") ;"dd/MM/yyyy 00:00:00")