DLM

Thanks Comment, worked perfectly! Hi Eos, I've both but this particular DB I was working on was on 5.5. Comment's formula did the trick, thanks anyhow. Best!

Hello all, I've FM 5.5 for Mac. I've a text field where I want to enter a validation by calculation where users are unable to enter any spaces, commas, dashes, periods or semicolons. What calculation may I use? Best,

I see what you're saying, the problem is that the dates already come like that (e.g., 2013-08-01) from the source excel which I receive from a provider...

Hi Daniele, a) The timestamp is a "timestamp" field. Yes, the result was "?" Now my head is also returning "?" :-)

Hi Wim, I tried as you stated but still get "?". In "Calculation result is" I tried number, time and text but same thing.... Real example: Start: 2013-08-01 14:45:04 End: 2013-08-01 14:46:10 Second difference: ? Any ideas? Best, Ciao Raybaudi, what do you mean? Please expound... Best,

I've two timestamp fields, one is "Start" and the other "End"... I've a third field called "Second difference".... What calculation should I use on the latter in order to get the seconds difference between each of the timestamps? Example: Start: 2013-08-01 14:45:04 End: 2013-08-01 14:46:10 Second difference: 66 <-- this is what I need And in some cases the End timestamp crosses to the next day, example: Start: 2013-08-01 23:58:30 End: 2013-08-02 00:02:15 Second difference: 225 <-- this is what I need I tried simply End - Start but it gives me a "?" as a result..... I also tried Seconds (End - Start) but same thing...

Hi Matt -- Thanks for that. Best!

Hi, I just got FM 12 (12.0v4 to be exact) so I'm new to it. I'm wondering if it's possible to import a batch of csv files in one shoot. I tried Import > Folder, then selected the folder where all the csv files are located, then clicked on "Text files" (rather than the default "Pictures and movies") but it won't work, I get "No files of the specified file type were found in the specified folder". Technically speaking I know that csv files aren't text files but there isn't a "Comma Separated" option which would be the correct one. Best,

P.S. And if the Seconds are 0 (zero) then the calculation would also show 0.

Hi guys, I'm using FM 5.5v1. I've a field call "Seconds" that simply shows the amount of seconds like this: 88 23 268 409 I would like a calculation that converts them into rounded minutes, following with the above examples the calculation would convert them as follows: 2 1 5 7 What calculation should I use? Best!

Hi doughemi -- The csv file does contain the timestamp but the problem is FM won't import csv (the file simply appears greyed out on the import window), that's why I saved the csv to xls... FM does import xls but when the import is done FM completely deletes the time part and just leaves the date, so if you would look at the excel formula bar it would show: 5/11/2013 10:25:41 AM But FM will only import this: 5/11/2013 I tried setting the field type to Text, Date and Time but same thing.

Hi Lee -- The problem is, as I explained on my original post, that when I import the data from excel FM completely deletes the time part and just leaves the date, so if on the excel formula bar it shows: 5/11/2013 10:25:41 AM Then FM will only import this: 5/11/2013 I tried setting the field type to Text, Date and Time but same thing.

Hi Lee! Yes, I'm really using 5.5v1 (call me a freak). There's no "Timestamp" field type (just Text, Number, Date, Time, Container, Calculation, Summary and Global) nor function. There's no "GetAsDate" nor "GetAsTime" functions either. :-( Any other options/ideas?

Hi LaRetta! It worked fine!! Thank you!

Hi guys -- I'm using FM 5.5v1, I want to import an excel file which has a column with many rows that have the date & time together, as follows: If you just look at the excel column it looks like this: 5/11/2013 10:25 5/11/2013 18:19 5/11/2013 20:33 etc. But if you click on each individual cell it looks like this: 5/11/2013 10:25:41 AM 5/11/2013 6:19:12 PM 5/11/2013 8:33:05 PM etc. Ideally, I would like to have it in FM under the 24 hour format as in the former but with the seconds included as in the latter, like this: 5/11/2013 10:25:41 5/11/2013 18:19:12 5/11/2013 20:33:05 etc. The problem is that when I import it, FM completely deletes the time and just leaves the date, I tried setting the field to Text, Date and Time but same thing. Any solution? Best! P.S. If it's not possible to do as I wish, how could I split the date & time so as to have them imported into two different fields?