Jump to content

Claris Engage 2025 - March 25-26 Austin Texas ×

The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Date Convert!

Questions King

By Questions King
February 21, 2006 in Calculation Engine (Define Fields)

Share

https://fmforums.com/topic/40841-date-convert/

This topic is 6883 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Questions King

Enthusiast

Questions King

Posted February 21, 2006

Posted February 21, 2006

anyone can help?

Creation Date Field is (6)mm/(2)dd/(2006)yyyy and I need convert to (06)mm/(02)dd/(06)yy...

any idea?? Thank!

aaa

Proficient

aaa

Posted February 21, 2006

Posted February 21, 2006

Hi, King!

Right("0"&Month(date),2)&"/"&

Right("0"&Day(date),2)&"/"&

Year(date)

MetaSys Software

Enthusiast

MetaSys Software

Posted February 21, 2006

Posted February 21, 2006

You can display the date in mm/dd/yy format, using 'Custom' option of 'Date Format' in layout mode.

Questions King

Enthusiast

Questions King

Posted February 22, 2006

Author

Posted February 22, 2006

Thank you all....aaa you get my solution!!! that is what I want...

This topic is 6883 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Share

https://fmforums.com/topic/40841-date-convert/

Go to topic listing

×

Browse
- Back
- Our Picks
- Blogs
- Clubs
- FM Events
- Events
- Site Support
  - Back
  - Guidelines
  - Staff
  - Feedback
- Gallery
Forums
Blogs
- Back
- Blogs
- Security Blog
Marketplace
Activity
- Back
- Leaderboard
- Online Users
- Search
- All Activity

×

Create New...

Important Information

By using this site, you agree to our Terms of Use.

I accept