Hello Saul,

I've responded to you via email. I will update this forum
thread accordingly.

Thank you for your patience.

Kyle

Hi Kyle,

I did not get any email on the subject.

Can you please send it again.

Shaul

Hi Shaul,

I've pasted the email that I sent you below.....

Hello Shaul,

I understand that you did post your question on the forum and thank you for doing that!

However, I did notice that the video you mentioned did not come through on the forum
and was wondering if it was possible for you to attach that to this email thread?

We would like to see the steps you took to input the CSV, how you converted the Varchar
to a TImeStamp, your attempt at the calculated field, and lastly, the version and build
of YF that you are currently using.

Is this possible? Please let us know.

Thank you.

Hi,

Here is the link to the video.

LINK

I am using Yellowfin Version 7.1 20141223


Shaul

Hi Shaul,

Thank you very much for linking in your video for
added clarification.

I will have a look at this and respond
accordingly.

Thank you for your continued patience.

Kyle

Hi Shaul,

thanks for the video link, what you showed looks like an issue and I will certainly follow up on it with the developers. However, in the meanwhile I've found a workaround which I'll show you now:

1) paste the following code at the bottom of your custom-function.xml file (appserverwebappsROOTWEB-INF) just before the final tag

[code]

To Timestamp

1
DateTimeVarChar
text



to_timestamp($1, 'DD/MM/YYYY HH24:MI:SS')


to_timestamp($1, 'DD/MM/YYYY HH24:MI:SS')
PostgreSQL
datetime
[/code]

save the file then restart Yellowfin.

2) create a new Calculated Field but this time choose Pre-Defined Formula as the Formula Type, then look for your new function.





3) and don't forget to set the variable





4) after saving that 1st Calc Field, then create the 2nd one that uses the MAX function on the previous Calc Field. This is where you were getting the error, however, this time it validates successfully





5) And then, here is a draft report using that Calc Field based on your test data, you can check the values.





Hope that helps, please let us know if you run into any problems.

regards,
Dave

great, glad the workaround helped. And thanks for the many Thanks!

regards,
Dave