Convert String to Date - DS 1.2

[Former Member]

Hello,

Has anyone converted a string date value i.e. 41517 = 8/31/2013 in Design Studio 1.2?  I checked the Convert function that is available and the options that are present are:

Is there a CAST function? or a method that would convert the example to a Date data type?  Any help would be appriciated.

Many thanks,

Kris

[XaviPolo · Accepted solution]

no Date type or Cast function 😞

[Former Member · Accepted solution]

Hi Xavier - thanks for the reply.  I didn't think so considering the Covert function has a limited listing of available methods.

[Former Member]

Hi,

I tried to do it with Design Studio 1.3, but it isn't so easy. Design Studio 1.3 still hasn't got date conversion functions. You can see my code in the attachment of this blog post:

If possible I would strongly advise to do it before your data gets into Design Studio by using for example abap or sql.

David