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

Best way to format date to yyyymmdd

Status
Not open for further replies.
fmrock

fmrock

Programmer
Sep 5, 2006
510
US
What is the best way to change a date to a string that is yyyymmdd?
 
Sort by date Sort by votes
This is what I am using now.

ToText({DATE_FIELD}, "yyyyMMdd")
 
Upvote 0 Downvote
So what problem are you running into?

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

Similar threads

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
488
TPG_IT
T
D
  • Locked
  • Question
Comparing two Date Ranges
Replies
0
Views
324
doodledump
D
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
460
mmck1964
mmck1964
ejastia
  • Locked
  • Question
date format spacing 1
Replies
4
Views
258
ejastia
ejastia
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
300
jchewsmith
jchewsmith

Part and Inventory Search

Sponsor

Back
Top