Report Builder Question
Question asked by Richard Mast - 9/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

2 Replies

Reply to Thread
0
Mark Culos Replied
Employee Post Marked As Answer
Richard,
 
In your data view, add a calculated field using the SQL function Cast(Stamp, Date).
0
Richard Mast Replied
That worked. Thanks Mark

Reply to Thread