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. Havin…

@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. [image] Adam_Maggs: ToDateTime(Format(“{1} {2}”, thisRow.Date.ToText(), thisRow.[Start Time].ToText())) Date, Time, Date/Time and Durati…

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

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…

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…

Thanks @Max_OBrien 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 …

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: !

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

Topic		Replies	Views
Day formula is calculating correctly but the cell is showing a wrong result	5	957	January 24, 2021
Ability to use calculated column as a duration Product Feedback	0	161	February 2, 2024
Estimate end date from start date and duration	11	2295	November 21, 2022
How to use 24 hour in formula?	9	1334	September 18, 2020
Conversion of the text into a date format	10	2517	July 3, 2022

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

Related topics