1
Report Builder Question
Question asked by Richard Mast - September 24, 2015 at 8:11 AM
Answered
Greetings!
We are needing a report on daily Card Authorizations with totals.  I've been able to do everything except group by date because the time stamp in the Stamp field makes every entry unique.  I need to truncate the field to just the date without the time and then group on that.  How do I extract just the date from this field?
Thanks in advance for your help.
Richard

1 Reply

Reply to Thread
0
Mark Culos Replied
September 24, 2015 at 9:57 AM
Employee Post
Richard,
 
In your data view, add a calculated field using the SQL function Cast(Stamp, Date).

Reply to Thread