Formula doesn't work with [Date Created]
Hello! Having a formula issue and I don't know if it is because I'm now using the built-in [Date Created] field or if there is another issue I'm just not seeing. In my old app [Release Date] work...
Forum Discussion
I'm guessing release date in the new app is a date/time field. Try Adding ToDate([Release date]) to your formulas above
------------------------------
GMacri
------------------------------
------------------------------
GMacri
------------------------------
Thanks! Release Date isn't a field in the new app.
In the new app, I'm using the built-in field [Date Created]. When I replace Release Date with Date Created, that's when I get the error.
------------------------------
Karen Henke
------------------------------
In the new app, I'm using the built-in field [Date Created]. When I replace Release Date with Date Created, that's when I get the error.
------------------------------
Karen Henke
------------------------------
- MarkShnier__You
Qrew Legend
Karen,
as @g.Macri says, the [Date Created] is field type date / time as opposed to being just a date.
I suggest that you create a formula date field called [Date Created in date format] with the formula
ToDate([Date Created])
Then use that in your formulas.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Dang, y'all are smart! Thanks so much!
------------------------------
Karen Henke
------------------------------
