Skip to main content
Solved

Using Variables in Formulas

  • February 11, 2020
  • 0 replies
  • 315 views

Hello all,

I'm trying to create a formula checkbox to check off between two hardcoded dates/times each month.

My current formula looks like this:
var DateTime FebPRStart = DateTime(02-01-2020 12:00 AM);
var DateTime FebPREnd = DateTime(02-15-2020 11:59 PM);
var Bool FebCalc = Today()>=$FebPRStart and Today()<=$FebPREnd;

Case
(Month(Today()) = 2,$FebCalc,true,false,

My problem is with the orange highlighted text. I was able to use the date variable when I started, but it seems like I cannot use the datetime the way I'm approaching it.

Does anyone have any ideas on how to include time in my variables and streamlining my formula in case I'm overcomplicating it.

Thanks for any help you can provide.

Best answer by AustinK

Without testing it I believe this one should work. It was missing some parenthesis in a few spots. A misspelled word and also using Today at the end instead of Now. This might work, if not post back.

This is just what Mark posted with those things adjusted.

var DateTime FebPRStart = ToTimeStamp(ToDate("02-01-2020"), ToTimeOfDay("12:00 AM"));
var DateTime FebPREnd = ToTimeStamp(ToDate("02-15-2020"), ToTimeOfDay("11:59 PM"));
var Bool FebCalc = Now() >= $FebPRStart and Now() <= $FebPREnd;
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • February 11, 2020
Uchenna,

Today() is a date
Now() will give you a Date Time

I think the issue is your BOOL.  Use Now() instead of Today()


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
MarkShnierYou
Forum|alt.badge.img+24
Uchenna,
There is no formula function called DateTime
Here is a list of of all the valid Quick Base Functions.  https://login.quickbase.com/db/6ewwzuuj?a=td

I think that you meant to use the function called toTimeStamp.
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=143&rl=bru


var DateTime FebPRStart = ToTimeStamp(ToDate("02-01-2020", ToTiimeOfDay("12:00 AM");
var DateTime FebPREnd = ToTimeStamp(ToDate"02-15-2020", ToTimeOfDay("11:59 PM");
var Bool FebCalc = Now() >= $FebPRStart and Today()<=$FebPREnd;








------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement