• anglina voltan 19
  • 0 Points
  • Member since 2022

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 3

I want to create a formula to use within a flow that outputs a DATETIME value using seperate inputs from a Date field and Time field. 

I have tried various different formulas, but have yet to get it working. For reference, I have been playing around with formulas such as:


However, none have worked thus far. Appreciate any insight or guidance on this one.

Thank you,

  • April 27, 2022
  • Like
  • 1

I've spent hours on this today (trial & error and searching help/forums) and hope one of you has an answer to this!


1.  I have a basic custom object where we've built many reports that hyperlink from that object - and feed a report formula automatically with data from a field on the object called "End Markets for Report Filters"  (benefit being we just clone the object page, change the name of the  End Markets for Report filters - for each end market team-- and then each report hyperlinked from that object works for all end market teams - they just go to their own page)


2.  The data in that field is passed through via a formula text hyperlink to a report with filter: 

 "End Market Group" (which is a custom field on opportunities) contains  [the data in the "end markets for report filters" field]


3.  Until recently, data in the "End Markets for Report Filters" field was pure text, such as "automotive", "communications", etc.  - and it worked fine


4.  But now I need to pass "I&I"through to the formula below-- just like I do today with "automotive"


HYPERLINK("00O60000001tGct?pv0=" & End_Markets_for_Report_Filters__c, "New Opportunities created Last 90 Days" )   ** <-- space between Days" and ) just to the left isn't there, but it keeps making a winking smiley face so I added a space


Question:  How can I pass a field that has an ampersand into the formula above?  My preference is to do it on the custom object - because I'm not sure if changing the formula above will impact the plain text pages.


What I've tried already:  On the custom object, I've tried changing the I&I with "I&I" or I"&"I or I'&'I  etc. 


Note:  If I edit the underlying report to....  contains... I&I (no quotes, nothing special), the report works fine.  It's just passing it through via hyperlinks on the custom object that's a problem (it comes through as contains  ,I    for example)


This impacts thousands of records that have "I&I" in that field name, so changing the core data so that I don't have to search on I&I isn't a good option.





  • January 22, 2010
  • Like
  • 1