Using conversion function in calculated column (analytic view)

[Former Member]

Hi everybody.

I have a column 'date' in my table.right now its defined as an INTEGER (yyyymmdd) and I want to convert it to a timestamp or date using the conversion function in a calculated column (in an analytic view). unfortunately the function i´m using isn´t working: date("DATE",8)

Any thoughts?

Regards, Christoph.

[Former Member · Accepted solution]

Hi Christoph,

Please use the date conversion function as below. It will converts the date as yyyy-mm-dd

date("DATE")

Thanks

Basha.

[rindia]

Dear Christoph,

In the table I took one of the date field DOJ  as integer.

           

I created Analytic view with calculated column on DOJ (renamed as Date_Of_Joining) as Joining_Date_Formatting as shown below

       

After activating the view, the calculated column will be shown as

     

I tried to change the date formats like yyyy-dd-mm in the expression editor but failing while validating the view.

Regards

Raj