ToDate function
I was just given the job of modifying a Quickbase database to prepare for a merger next week. I come from the SQL world. There is one field they want changed that I need help with. The current cod...
Forum Discussion
When you get into complex formulas, the syntax gets quirky really quick.
Your option in an If Statement structure should work they way you wish:
If(
------------------------------
Ryan Stanford
------------------------------
Your option in an If Statement structure should work they way you wish:
If(
ToDate([Date Created])<Date(7/1/2020,1,1),("E" & Right(ToText(Year(ToDate([Date Created]))),2)
&("-" &([Envoy PN 2019])))),
If(
ToDate([Date Created])>Date(7/1/2020,1,1),("P" & Right(ToText(Year(ToDate([Date Created]))),2)
&("-" &([Envoy PN 2019])))),
null))
the null part might be "", depending on field type, but you get the idea.
------------------------------
Ryan Stanford
------------------------------
