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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formual Field 1

Status
Not open for further replies.
jchewsmith

jchewsmith

Technical User
Nov 20, 2006
161
US
Is there a way to assign a field type to a formula field? I want to make it a date instead of a date time.
 
Sort by date Sort by votes
You need to change the formula to return a date instead of a datetime, e.g.:

if {table.field} = "X" then
date({table.datetime})

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
242
hilfy
hilfy
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
271
socalvelo
socalvelo
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
314
Cpreston
Cpreston
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
355
SarahSCPDAdmin
SarahSCPDAdmin
jchewsmith
  • Locked
  • Question
Formatting an embedded field in Crystal 2016 Support Pack 5 1
Replies
3
Views
289
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top