Navigation

    APPDRAG Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular

    REMINDER

    Please be respectful of all AppDragers! Keep it really civil so that we can make the AppDrag community of builders as embracing, positive and inspiring as possible.

    Date Functions?

    Cloud Backend (Cloud DB, API Builder)
    2
    4
    332
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • J
      John Lamb last edited by

      When trying to create a visual select to get the current date, current week or current month n the parameters for the formula how is it Currentdate() or something else?

      1 Reply Last reply Reply Quote 0
      • Joseph Benguira
        Joseph Benguira last edited by

        If you want to format the date I recommend you instead of Visual Select to use RAW Select, there you can use SQL Power to format your date when selecting it

        https://www.w3schools.com/sql/func_mysql_date_format.asp

        1 Reply Last reply Reply Quote 0
        • J
          John Lamb last edited by

          not trying to format like for example when doing where statements in the visual select sometime there is a case for Now() i am asking is it possible for CurrentDate() or getdate()

          1 Reply Last reply Reply Quote 0
          • Joseph Benguira
            Joseph Benguira last edited by

            In VisualSQL, Formulas can be user in WHERE conditions ... not to format the selected data and the output ... you can do that only in Raw SQL

            1 Reply Last reply Reply Quote 0
            • First post
              Last post