View-->Prepare-->DateFunction Create Error

Rick Sharp shared this question 1 year ago
Answered

Using the "Submit Date" Remedy field and Assuming YellowFin documentation instructions applies to SR in use.

System Information Application Version: 7.35 Build: 20170512 Java Version: 1.8.0_92 Operating System: Windows Server 2012 R2 6.3 (amd64) We need to add a Date Function field to a View, and get this error? (see screenshot below)

And we set the System Setting to NOT PREVIEW LIVE DATA.

https://community.yellowfinbi.com/topic/prepare-stage-of-view-builder-is-slow


We are trying to create a Date Function field to show the Week Start on a report; i.e. 1/1/2018 versus 1st Week.


On the YellowFin User Guide, this is supposed to be possible.

Date Functions - Yellowfin Guide 7.3 - Yellowfin Wiki

How do we create a field on view, to show Week Start.

We don't want to see 23 or 23rd, but rather the first day of the business week, for which it was submitted:

We want to see June 4, 2017, which is Sunday of this business week.


396f54233198bce44392d5c611348c06

Comments (3)

photo
1

Hi Rick,

So first off, it looks like you are using BMC Remedy, which means that the first stop for any questions you have is to go through BMC support.

That said, it is difficult to tell what is going wrong from this error alone. Can you send me the logs that correlate with this time? Typically these can be found in your yfinstallationfolder/appserver/logs folder however, since you are a remedy customer you will probably need to contact them for these as well.

Sorry I cant be of more help!

Regards,

Nathan

photo
1

We logged a ticket with Remedy as well......I was hoping to hit both and get an answer quicker. I will wait for them to respond back, Nathan!

Thanks!

photo
1

Sounds good! I actually had a chance to test this on a BMC specific instance and was able to replicate what you are seeing (Though this works as intended in non-BMC builds), so hopefully they will be able to provide more information on why that is.

Regards,

Nathan

photo