Jump to content

Woolf

Members
  • Posts

    4
  • Joined

  • Last visited

Woolf's Achievements

  1. Thanks. This is exactly what I was looking for!
  2. How would I grab all the text in an email address BEFORE the @ sign? I am trying to create a login address that matches our other systems. But I cannot figure out how to get the SUBSTRING of just the front of the email address. For example: If the email address were MMouse@business.com, then I would want to create a USER_NAME variable that is just MMouse. Any suggestions?
  3. Depending on which version of a product a person uses, I am trying to get a new date that is 14 days AFTER the original date. This I already figured out how to do. CASE WHEN [@field:Brand_Received] = 'Brand 1' THEN Dateadd(day, 14, [@field:Date_1]) WHEN [@field:Brand_Received] = 'Brand 2' THEN Dateadd(day, 14, [@field:Date_2]) END But then I need to determine if the new date (14 days after the original date) is BEFORE whatever the current date is (which would change depending on when the user accessed the report).
  4. I need to be able to calculate a date, created by a formula, which is prior to whatever the current date is. That sounds easy but I cannot figure out how to do it in my specific situation. Because I needed to determine a date that was 2 weeks after a date entered based on two different scenarios I created this formula in my data table: CASE WHEN [@field:Brand_Received] = 'Brand 1' THEN Dateadd(day, 14, [@field:Date_1]) WHEN [@field:Brand_Received] = 'Brand 2' THEN Dateadd(day, 14, [@field:Date_2]) END It works well to give me the date that is two weeks after the specific date given, based on unique requirements. However, now I need to create a field that checks to see if the new Formula Date is before whatever the current date is. I have not been able to get a result for this. Caspio does not allow me to use results from one formula field as variable in another formula field. And I have not been able to figure out just yet how to combine all the variables I need to produce a valid formula. Any thoughts?
×
×
  • Create New...