Skip to Content
avatar image
Former Member

Function AlaDate

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.

Add comment
10|10000 characters needed characters exceeded

  • 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.

  • 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".

  • 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

  • Get RSS Feed

2 Answers

  • Nov 14, 2017 at 10:33 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2017 at 10:49 AM

    Thank you very much

    Add comment
    10|10000 characters needed characters exceeded