
DLM
Members-
Content Count
52 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout DLM
-
Rank
novice
Profile Information
-
Gender
Not Telling
-
How to stop users from entering certain characters
DLM replied to DLM's topic in Calculation Engine (Define Fields)
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! -
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
-
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,
-
How to convert seconds into rounded minutes
DLM replied to DLM's topic in Calculation Engine (Define Fields)
P.S. And if the Seconds are 0 (zero) then the calculation would also show 0. -
How to convert seconds into rounded minutes
DLM posted a topic in Calculation Engine (Define Fields)
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! -
Date & time field: Importing from excel
DLM replied to DLM's topic in Calculation Engine (Define Fields)
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. -
Date & time field: Importing from excel
DLM replied to DLM's topic in Calculation Engine (Define Fields)
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. -
Date & time field: Importing from excel
DLM replied to DLM's topic in Calculation Engine (Define Fields)
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 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:1