MelanieProebste
Qrew Trainee
Joined 2 years ago
User Profile
User Widgets
Contributions
Formula Assistance - Comparing Two Dates
I need assistance with this formula. I am trying to formulate the following: - If the date in the CAT - Cats Complete Date field is in the same month and year as the date in the Monthly Period field, then return 1, otherwise return 0. CAT - Cats Complete Date is a date/time field Monthly Period is a date field If(LastDayOfMonth(ToDate([CAT - Cats Complete Date]))=LastDayOfMonth([Monthly Period]), 1,0) ------------------------------ Melanie Proebstel ------------------------------How to write Rich Text HTML to have Multi-Colors
How would I revise this code to have the word ORANGE in color #FFA200 and then the rest of the sentence in green again. "<div style=\"color:#34a853;font-size:300%;font-weight:bold;\"align=\"left\">"&"To update the work ticket: Please use the orange SAVE AND RETURN TO MRI button ABOVE to save this review and update the work ticket."&"</div>" ------------------------------ Melanie Proebstel ------------------------------Re: URL Button to Open form in another app
Hi Mark, I want this button in my app (bsb76aszn), but to push to app (btbcahsih), table [_DBID_POWER_CLEAN]. When I enter the way you have noted, it tells me the [_DBID_POWER_CLEAN] table is not in the app (bsb76aszn). Is it possible to button between two different apps, not two different tables? Many thanks for all your expertise here. Melanie ------------------------------ Melanie Proebstel ------------------------------Re: URL Button to Open form in another app
Hi Mark - Can you write out how this should look? I am in one app, but want this button to look at another table in another app. Is this how you would notate? URLRoot() & "db/btbcahsih" & [_DBID_POWER_CLEAN] & Thank you, Melanie ------------------------------ Melanie Proebstel ------------------------------
