Joined: 28 May 2013
Online Status: Offline
Posts: 93
Topic: Difference in dates and text Posted: 05 Jun 2014 at 2:18am
In a report I need to show the length of time in days that has passed. if there is a null in my field I prefer to have a text note. My formula reads
if isnull({table.shipdate}) then "Item Not Shipped" else totext(today - ({table.shipdate})
I would like to edit the way the number is displayed in my report by removing the decimals. If the item was "shipped" today i would like it to be a 0 vs .44.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum