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 Rhinorhino 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
Joined
Apr 20, 2007
Messages
10
Location
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 Question
Using "OR" to select data
Replies
4
Views
1K
mmck1964
mmck1964
SarahSCPDAdmin
  • Locked
  • Question Question
Can I format data in a memo field?
Replies
5
Views
764
SarahSCPDAdmin
SarahSCPDAdmin
socalvelo
  • Locked
  • Question Question
Date Range Formula - Data from two months ago only
Replies
4
Views
796
pmax9999
pmax9999
J33
  • Locked
  • Question Question
Monthly exchange rates, select only newest rate on each currency for currency conversion on row
Replies
6
Views
707
J33
J33
jlr123
  • Locked
  • Question Question
If then else question
Replies
2
Views
393
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top