Newbies JMDiniz Posted February 2, 2005 Newbies Share Posted February 2, 2005 Hi there, I need to create a field for a call center database, where this field sould contain the Date & Time together, i.e., when I create a new record, this fiels is our Call Log number. Ex.: the client call today 2005/02/02 at 15:03 I need that in the fiel appear this--> 200502021503 Is it possible? Anyone can help me? Thanks in advance. Regards JD Link to comment Share on other sites More sharing options...
rdhaden Posted February 2, 2005 Share Posted February 2, 2005 In FM7, the field type is time stamp. In FM6, it would be a text calculation, DateToText (date) & " at " & TimeToText (time) date and time would be date and time fields with auto-enter creation date and auto-enter creation time. Link to comment Share on other sites More sharing options...
-Queue- Posted February 2, 2005 Share Posted February 2, 2005 Year(datefield) & Right( "0" & Month(datefield), 2 ) & Right( "0" & Day(datefield), 2 ) & Right( "0" & Hour(timefield), 2 ) & Right( "0" & Minute(timefield), 2 ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7015 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 accountSign in
Already have an account? Sign in here.
Sign In Now