'5/6/2015 7:00 AM' to '5/6/2015'

ToDate([date time field]) My formula is better as it preserves the UpperCamelCase of the documentation and is easier to read. Many aspects of QuickBase are case insensitive but your formulas and URL actions are more readable when using the appropriate case. Wikipedia on CamelCasehttps://en.wikipedia.org/wiki/CamelCase

But when you save the formula, QuickBase fixes the CapiTalization of the formula fUnctions and the field names, so yes, I was just being lazy knowing it would clean up my sloppiness. But I do agree that sometimes when you are comparing to some text field = " A text String" or a Contains function, I have not totally nailed down when the Case matters.

>But when you save ...Maybe true but it also applies to the "actions" and formulas. I would stay away from these variants and use consistent capitalization:?a=TD?act=api_editrecordDBID()

What field type do I use for this formula? Formula Text, Formula Date, Formula Date/Time, etc.?

How can one convert a ""Date/Time"" value to a ""Date Only"" value?

Jay_DDS_
Qrew Cadet
8 years ago
Worked like a charm! I had done that, but had the wrong field type. I had Date/Time instead. So, next question would be, how can i populate a field with the time a field is changed. Currently, I have this in the formula url, but it still prints the date AND time. Is there something I can do to make it just print the time?

& "&_fid_20=" & URLEncode (Now())
QuickBaseCoachD
Qrew Captain
8 years ago
try this, assuming that fid 20 is a time of day field (or I guess a text field) .

& "&_fid_20=" & URLEncode (ToTimeOfday(Now()))

Forum Discussion

How can one convert a ""Date/Time"" value to a ""Date Only"" value?