Skip to Content
0

Function AlaDate

Nov 14, 2017 at 09:54 AM

39

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

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")

0
Former Member

=(UserResponse ([Requête 1 avec CIC] ; "Date de Début"))

CIC is the universe

"Date de Début" is the demand in the prompt

0

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.

0
Former Member

In english is :

=ToDate(UserResponse ([Requête 1 avec CIC] ; "Date de Début");"DD/MM/YYYY")

Webi says "The formula is defined correctly".

0
Former Member

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Nov 14, 2017 at 10:33 AM
1

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")

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 14, 2017 at 10:49 AM
0

Thank you very much

Share
10 |10000 characters needed characters left characters exceeded