Hide Date

Follow

Mark Lanks

• September 20, 2016 18:55

I have a date field calculation that is referencing a date in a referenced app. 

moment(@Min of Tickets on Sale Date).tz('America/New_York').toDate()

 It works great when there is a referenced entry with the date field filled in.  However, there are many entries where there is either not an entry referenced or not a date in the referenced field.  Since it's a date-based calculation field, I can't figure out how to get it to display nothing in these cases.  I've tried doing something like 

@All of Tickets on Sale Date != "" ?
moment(@Min of Tickets on Sale Date).tz('America/New_York').toDate()
: ""

but it gives me an "Invalid value null (null): must be to_datetime or null or to_date or null" error.

Can someone help?

 

0

• 

  Rainer Grabowski

  • September 21, 2016 11:31

  Hi Mark,

   

  don't care about that notification, disregard it, save it and all is good :-)

  Rainer

  0

  Comment actions Permalink
• 

  Mark Lanks

  • September 21, 2016 13:25

  Rainer-

  Thanks!  I should have thought to try that, but I was trusting Podio's mesage.  Silly me.

  Mark

  0

  Comment actions Permalink

Please sign in to leave a comment.