UchennaOgbejesi
Qrew Trainee
5 years ago
Solved

# Using Variables in Formulas

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.

• 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;

### 8 Replies

• 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.

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
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
• Thank you very much, Mark! I'm having an issue with the semicolon at the end of the first line. It says it is expecting an ). But, when I put that, it highlights the ToTimeofDay piece.

------------------------------
Uchenna Ogbejesi
------------------------------
• AustinK
Qrew Commander
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;
• DonLarson
Qrew Commander
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
------------------------------
• Thanks for your response. It helped to point me in the right direction.

------------------------------
Uchenna Ogbejesi
------------------------------