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

Change Date Format

Status
Not open for further replies.
NorthStarDA

NorthStarDA

IS-IT--Management
Mar 16, 2004
614
US
Hi,

Does anyone know how I can use a calculation to change a Date field into a format like 'YYYY-MM-DD' so I can import into an SQL database using ExecuteSQL?
 
Sort by date Sort by votes
figured it out:

Year(date_created) & "-" & Right("00" & Month(date_created), 2) & "-" & Right("00" & Day(date_created), 2)

thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cchildress
  • Locked
  • Question
Determining recent activity by date
Replies
1
Views
134
JeanW
JeanW
otherr
  • Locked
  • Question
change value after a certain date
Replies
0
Views
74
otherr
otherr
CryoGen
  • Locked
  • Question
Day & Get(Current Date) calc
Replies
2
Views
498
CryoGen
CryoGen
rlowe82
  • Locked
  • Question
FileMaker: Accidental Change! HELP!!!
Replies
1
Views
64
philhege
philhege
tcoyle777
  • Locked
  • Question
Date Calc Question 1
Replies
11
Views
160
tcoyle777
tcoyle777

Part and Inventory Search

Sponsor

Back
Top