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?
-
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?
-
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
-
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()
-
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