Jump to content


  • Posts

  • Joined

  • Last visited

Vad21's Achievements

  1. So I have used Case Select statements for some time and never ran into the roadblock I have today. Not quite sure if it is a caspio limitation or issue or if I am just snow-blind to the situation and can not see my mistake. The code below I have placed in a calculated field on my report and it works fine until I put the DateDiff statement at the end. The same Datediff worked fine independently but not in this case statement. Any help would be soooo appreciated. TY:) CASE WHEN [@field:Estimate_Sent_To_FS_Date] IS NOT NULL THEN "Complete" WHEN [@field:Canceled_Date] IS NOT NULL THEN "Canceled" ELSE Datediff(day,[@field:Eval_Fax_in_Date],GetDate()) END
  • Create New...