Conversion of the text into a date format

The attached table contains the columns ‘Date, From, To’. The data in these columns are in text format and I would like to convert them into dates so I can use them to create a calendar view. I would be more than grateful for any help. Thanks.

It can be done with one large formula, but I think it is better to use additional column you can hide:

1 Like


Thank you but I can’t copy the document to see your solution. For unknown reasons there is no copy doc button

Changed access mode to edit, cant you see formulas in columns?

Now I can. Thank you. I still have a lot to learn. On the other hand, I would like to know how to learn the formulas. I am a psychologist by education and the first steps are really hard for me. Anyway, I am not going to give up.

One more question: When I have the calendar view, the months change every two months and I can’t move months forward but only backwards. Why is that?

Could you show this problem with some example, please?

I’d love to, but I don’t know how. Maybe I will ask you differently. Can you turn on the calendar view for the month of April?

I see this is already done for May, so I switched to April.

UPD. Oh, it seems that Calendar View don’t remember last month selected and defaults to current one. There is also setting to change default to First event of Last event, not to choosen month.

Hello Denis! I am struggling to make start and end datetime columns for a calendar view from separate date, start_time, end_time columns. Could you please share once again the fomulas you are using in your doc?

:wave: Hey there!

Dates (and times) are in the background are actually numbers in Coda.

Days are whole numbers, and times are fractions (12pm in a day would be = 0.5)

Therefore if you have date/time columns and want to combine them into date/time values for calendars, timelines, etc you can simply add them

Then just set that column type to date/time!


or you use the number function Sum()

but the Date + Time reads better :wink:

1 Like