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

extracting date from a date time field

Status
Not open for further replies.
SmithyJD

SmithyJD

IS-IT--Management
Sep 23, 2004
52
GB
I have a datetime field in the sql data base I am working with but am only intereted in the date is it possible to extract this to another variable

Thanks in Hope

JD
 
Sort by date Sort by votes
Maybe I'm missing something, but I'd use a formula such as:

Code: 
date(date_time_var)

You also may want to look at the date functions in help.

damon
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
429
doodledump
D
B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
335
hilfy
hilfy
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
429
socalvelo
socalvelo
PJ222
  • Locked
  • Question
is date within any date range in a dynamic array of date ranges
Replies
1
Views
295
PJ222
PJ222

Part and Inventory Search

Sponsor

Back
Top