calculation date display

Follow

Jakob Rosenfeldt

• March 10, 2017 12:20

Hi, 

I want to have a calculation field displaying something in the lines of

Tommerup, 17th of May 2017, USA

The eligeble fields are 

@Infodag by = text field (City name)

@Mødedato = datef field

@Infodag fokus = text field (additional info)

My initial calculation looks like this. 

Is there any way to make it be in the lines of Tommerup, May 17 2017, USA ? 

 

thanks

0

• 

  Hamid

  • March 10, 2017 12:38

  Hi Jakob,

  To format date use moment() : doc at https://momentjs.com/docs/#/displaying/

  var date = moment(@Mødedato).format("MMM DD YYYY")
  @Infodag + ", " + date + ", " + @Infodag fokus
  

  0

  Comment actions Permalink
• 

  Jakob Rosenfeldt

  • March 10, 2017 13:09

  thanks Hamid. 

   

  

  what am I doing wrong? 

  0

  Comment actions Permalink
• 

  Hamid

  • March 10, 2017 13:27

  In the seconde line replace @Mødedato by date

  like this:

  @Infodag by + ", " + date + ", " + @Infodag fokus

  0

  Comment actions Permalink
• 

  Jakob Rosenfeldt

  • May 03, 2017 09:08

  Could you help me out again? 

  For some reason it subtracts one day. 

  In the calendar input is 28th of May and in the visible part it's 27th. 

  How come? 

  

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • May 03, 2017 10:02

  Hello Jakob,

  add your timezone (the same as in your Podio Account settings). My timezone eg is Europe/Berlin.
  
  

  var date = moment(@Mødedato).tz("Europe/Berlin").format("MMM DD YYYY");

  0

  Comment actions Permalink
• 

  Jakob Rosenfeldt

  • May 08, 2017 12:44

  thanks Rainer. 

  I think you've put in an answer in every post I've made here. You're brilliant. 

  Altering the hour of the event also caused the thing to change the date. 

  0

  Comment actions Permalink

Please sign in to leave a comment.