Why can Calendar use formula results column for Duration but not for Start Date & Time?

Is there a reason why Calendar can use formula results column for Duration but not for Start Date & Time? Is it likely a programming constraint or a design decision? I’m curious to know if this will always require a workaround or if there’s a chance it will be improved sometime in the future.

Having to use a manually inputted (non formulaic) Date & Time column type - for the Calendar display to work - makes data entry workflows more clunky and resulting tables much less flexible.

i dont understand.

i use formulas to define start dates all the time without problems.


1 Like

The only reason I can think of for formulaically Date/Time field(s) “not working” in a Calendar display is when the concerned Date/Time field(s) don’t effectively return a Date/Time but a list of Date/Time values (most likely a list of 1 Date/Time) :thinking:

At least, this seems to be a somewhat common issue for a Timeline display so I guess it could be the same for a Calendar display :innocent:.

Other than that, as @Xyzor_Max said, it’s completely feasible to use formulaically defined Start Date/Time in a Calendar display :blush: .

another possible issue is that start-date, end-date and duration are all dependent variables, ie dependent on each other.

so you can set any two of those and compute the third from that.

and if you try to move the time-line bar to adjust those variables, you wont be able to adjust any of them that have formulas.


2 posts were merged into an existing topic: Capture redirected page URL into coda form

Thanks @Xyzor_Max and @Paul_Danyliuk - turns out it was the formula I using to try combine a Date and Start Time column into a Date & Time. ChatGPT helped with this:

ToDateTime(Format(“{1} {2}”, thisRow.Date.ToText(), thisRow.[Start Time].ToText()))

Which has worked. Thanks for making me realise it was possible!

@Adam_Maggs: Depending on your actual setup, you might not necessarily need to go through this formula to create a Date/Time using a Date and a Time field.

Date, Time, Date/Time and Duration are just numbers under the hood :blush:

So, you can actually add a Time value to a Date one to create a Date/Time

(See the field [Resulting Date/Time] in the sample below)

Oh wow! Thank you, that’s so much easier! I was trying concatenate and other options - hadn’t realised. Super appreciated @Pch

My pleasure @Adam_Maggs :grin: !

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.