ToDate function

[Former Member]

Hi folks,

Have SAP BI4 SP3 and usualy I'm using todate function to convert string in date.

On related version can't find anymore =todate function in the list of functions !!!!????

Any helping hand ?

Best regardsn

[arijit_das · Accepted solution]

It is present under Date & Time folder in formula editor. Where are you looking at ? Can you give one screenshot ? Also, what is your preferred viewing locale (Check with =GetPreferredViewingLocale() function) ?

[Former Member]

Sorry guys,

I was confused because of the language used. Now it’s ok, I find out by my self.

In fact, what was really happened and what is really new with SAP BIP4.1 SP3, is the the fact that in versions prior 4.1 the “=ToDate” function was translate in French “=EnDate”, or in SAP BIP4.1SP3 they have made a new translation like '=AlaDate' for French (=ToDate in English version)

Thanks a lot for your kindly help.

Best regards,

Bogdan

[nscheaffer]

I think the function you want to use is FormatDate.

This blog post has numerous examples of what is possible...

Web Intelligence Date Formats | Business Objects Blog

Noel

[nscheaffer]

FormatDate will only work if the data type of your input is Date.  So I believe ToDate is the function you want to use.

I am not sure why you cannot find it anymore.  Here it is in the "Date & Time" folder within the list of functions.

Noel