Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data conversion question

Status
Not open for further replies.
lowester

lowester

MIS
Apr 20, 2007
10
US
Good Morning,

there is a number field in the sql table that shows it as:
1,504,192,818,318.00 which in the form displays as Aug 31, 2017 11:27 AM

Any idea how to convert in crystal to display it as Aug 31, 2017 11:27 AM instead of the large number?

thanks,
Tim
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
317
mmck1964
mmck1964
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
211
SarahSCPDAdmin
SarahSCPDAdmin
socalvelo
  • Locked
  • Question
Date Range Formula - Data from two months ago only
Replies
4
Views
232
pmax9999
pmax9999
J33
  • Locked
  • Question
Monthly exchange rates, select only newest rate on each currency for currency conversion on row
Replies
6
Views
210
J33
J33
jlr123
  • Locked
  • Question
If then else question
Replies
2
Views
109
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top