Skip to main content
Question

Date variable App Wide

  • Feb 22, 2018 7:34 AM UTC
  • 0 replies
  • 89 views
I have some fields which will need to show results based on financial year start and end date.   Instead of hard coding, it there a way we could keep these values somewhere which could be used across app and updated as and when required. 
      This topic has been closed for replies.

      There is a little used feature in Quickbase called application variables. They are accessed through

      Settings

      Variables

      They are limited in that the field type is only text. However you can still use them for your purposes. For example you could have an application very bold called

      Current fiscal year start

      With the value of

      June 28, 2017

      Them anywhere in your app you can use the formula

      ToDate([Current fiscal year start])

      So you were for to the application variable in square brackets just like any other field, except that the field will not be listed in any field less. It will be a globally available in all tables in that single app.

      Of course, it is then totally up to you to remember to update the application variable when the year rolls around.

      https://help.quickbase.com/user-assis...
      • ArshadKhwaja
      • Author
      • Qrew Corporal
      • Feb 22, 2018 8:33 AM UTC
      Thanks a lot.  Do need any special format to create the value or can I just add a date "30/06/2017" and that will come across as text and then converted to date. 
      You will need to test based on your date setting in your app. I suggest using English words like my example or else you will need to test if it recognizes your Australian DDMMYYYY Date Settings.
      • ArshadKhwaja
      • Author
      • Qrew Corporal
      • Feb 22, 2018 11:43 PM UTC
      Thanks.  This works fine with the example I used.  Many thanks for the insight. 
      Terms & ConditionsAccessibility statement