Forum Discussion

UchennaOgbejesi's avatar
UchennaOgbejesi
Qrew Trainee
5 years ago

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.

Thanks for any help you can provide.

Formulas and functions
  • AustinK's avatar
    AustinK
    5 years ago
    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;
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    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
    ------------------------------
    • UchennaOgbejesi's avatar
      UchennaOgbejesi
      Qrew Trainee
      5 years ago
      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's avatar
        AustinK
        Qrew Commander
        5 years ago
        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's avatar
    DonLarson
    Qrew Elite
    5 years ago
    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
    ------------------------------
    • UchennaOgbejesi's avatar
      UchennaOgbejesi
      Qrew Trainee
      5 years ago
      Thanks for your response. It helped to point me in the right direction.

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