Jump to content
edmeldc

PdmToday getting yesterday date

Recommended Posts

Hi All,

I created an object in the universe. I added the object in Incident Activity folder. I also created a filter that will calculate the date range for the report.

Object I put this on the select box:

PdmToday(1,-1,0)

But when I add the object in my report in InfoView its not accepting the object its giving me an error.

Can anyone help me solve this issue?

post-7451-1399615273_thumb.png

Share this post


Link to post
Share on other sites

Try adding this calculated field on a non-related table like 'dlgsrv' and not directly on the Incident Activity Folder. Or just create a new filter on the Incident Activity where you can use 'PdmToday...' as a 'where' clause for filtering.

Share this post


Link to post
Share on other sites
Try adding this calculated field on a non-related table like 'dlgsrv' and not directly on the Incident Activity Folder. Or just create a new filter on the Incident Activity where you can use 'PdmToday...' as a 'where' clause for filtering.

Thanks, I will try this.

Share this post


Link to post
Share on other sites
Thanks, I will try this.

Hi Mitu,

Still does't work.

Im really puzzled with this problem.

On other reports its working. I just create the object in the universe then use it on the web intelligence report and it works fine for other reports.

The object I created before on the Incident Detail works fine. I did the same approach with the Incident Activity but it does not work.

post-7451-1399880771_thumb.png

Share this post


Link to post
Share on other sites

I have always used 4 numbers PdmToday(-1,-1,0,0)

Hi All,

I created an object in the universe. I added the object in Incident Activity folder. I also created a filter that will calculate the date range for the report.

Object I put this on the select box:

PdmToday(1,-1,0)

But when I add the object in my report in InfoView its not accepting the object its giving me an error.

Can anyone help me solve this issue?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...