Skip to main content

Dear community 

I’m a nubee here. Trying to schedule a non profit festival.

Is there a formula for getting start and end time into the same column? 

Such as: 

DATETIME_FORMAT({Start Date},'dd. DD. HH:mm'), which is already pretty good.
 
This gives me ie.: Mo. 25. 09:30

I would for the sake of sharing like to include the {End time} ie (11:15) to get this appearance:
Mo. 25. 09:30-11:15
 
Is there a formula to do this?

I tryed DATETIME_FORMAT({Start Date},'dd. DD. HH:mm')DATETIME_FORMAT({End Date},'HH:mm'), but it does not work.
Hoping for an answer.🙏 Uffe from KlaDa
 

Hey Uffe! Try to use the " & " operator to concatenate the formatted date fields, and add a separator if needed, such as a space or comma. This formula should work:

DATETIME_FORMAT(Date1, 'YYYY-MM-DD HH🇲🇲ss') & ' | ' & DATETIME_FORMAT(Date2, 'YYYY-MM-DD HH🇲🇲ss')

 

Try:

DATETIME_FORMAT({Start Date},'dd. DD. HH:mm') & "-" & DATETIME_FORMAT({End Date},'HH:mm')

Perfect, thank you so much, both of you!

Hugs

Reply


Terms & Conditions