Removing time from showing in a referenced date field in a calculation.

Follow

Charl Henning

• October 25, 2016 09:46
• Edited

We referenced a date field in a calculation. Turning of the time part in the original date field did not prevent it from showing in the calculation field. Can one show the date and not the time?

 

Thanks

0

• 

  Kent Watson

  • October 26, 2016 09:35

  Hi Charl,

  You could use the following.  I'm not sure if there is a better way to do it but this will work

  If you are referencing from the same app

  var d = @Date
  d.getDate() + "/" + d.getMonth() + "/" + d.getFullYear()

  if you are referencing from a related app

  var d = @All of Date[0]
  d.getDate() + "/" + d.getMonth() + "/" + d.getFullYear()

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • October 27, 2016 19:36
  • Edited

  Hi Charl,

  I assume you display the date in the calculation field like a "real" date field. So the calculation is date type (calc. fields can be date, number or text type). In the template creator every field has a little triangle on the left side, this is for field settings. Click it and deselect "Show time". It will still be shown in the calc. preview, but not in the item view.

  Rainer

  0

  Comment actions Permalink
• 

  Charl Henning

  • October 28, 2016 09:47

  Thanks for that. It works. However, some of the items in the app now show nothing in the calculation field...

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • October 28, 2016 13:04
  • Edited

  How do you pull the date into the calculation field?
  With @all of date or @max of date (or @min of date)?
  Are more than 1 items related?
  What does the calculation preview show in those items where now nothing is shown?
  Can you share a screenshot of your calculation field?

  Rainer

  0

  Comment actions Permalink
• 

  Charl Henning

  • November 02, 2016 10:04

  Hi Rainer. I will test and get back to you thanks.

   

  0

  Comment actions Permalink

Please sign in to leave a comment.