inject date into formula date

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I'm trying to create a formula that would inject a specific date into a formula date field if a condition is met. It looks something like this: Case([Week of], "Week of 04/25/2016","04-25-2016", "Week of 05/02/2016","05-02-2016", "Week of 05/09/2016","05-09-2016", "Week of 05/16/2016","05-16-2016", "Week of 05/23/2016","05-23-2016", "Week of 05/30/2016","05-30-2016", "Week of 06/06/2016","06-06-2016", "Week of 06/13/2016","06-13-2016", "Week of 06/20/2016","06-20-2016", "Week of 06/27/2016","06-27-2016", "Week of 07/04/2016","07-04-2016", "Week of 07/11/2016","07-11-2016", "Week of 07/18/2016","07-18-2016", "Week of 07/25/2016","07-25-2016", "Week of 08/01/2016","08-01-2016", "Week of 08/08/2016","08-08-2016", "Week of 08/15/2016","08-15-2016", "Week of 08/22/2016","08-22-2016", "Week of 08/29/2016","08-29-2016", "Week of 09/05/2016","09-05-2016", "Week of 09/12/2016","09-12-2016", "Week of 09/19/2016","09-19-2016", "Week of 09/26/2016","09-26-2016", "Week of 10/03/2016","10-03-2016", "Week of 10/10/2016","10-10-2016", "Week of 10/17/2016","10-17-2016", "Week of 10/24/2016","10-24-2016", "Week of 10/31/2016","10-31-2016", "Week of 11/07/2016","11-07-2016", "Week of 11/14/2016","11-14-2016", "Week of 11/21/2016","11-21-2016", "Week of 11/28/2016","11-28-2016", "Week of 12/05/2016","12-05-2016", "Week of 12/12/2016","12-12-2016", "Week of 12/19/2016","12-19-2016", "Week of 12/26/2016","12-26-2016" ) The problem is that it says i can't because the formula returns a text result. Any suggestions would be appreciated.
Photo of Igor

Igor

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Try this version. Short and sweet.

ToDate([week of])
Photo of Igor

Igor

  • 0 Points
Tried that, not working. Could it be because of the date format?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
i would have to test.  It may need to be changed to a formula that calculates to 04-25-2016
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Sorry, I was being stupid, duh,

ToDate(Right([Week of],10))
Photo of Igor

Igor

  • 0 Points
Like a charm! Thanks!