-
FlexPro
- Auf einen Blick
- Features & Optionen
- Einsatzgebiete
- Alle Vorteile
- Neu in FlexPro 2021
- FlexPro gratis testen
- FlexPro View OEM Freeware
- Kaufberatung
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produkte
- News
- Support
- Unternehmen
- Jobs
- Kontakt
- Login
- Language
- +49 6894 929600
- infoweisang.com
- Google Maps
Microsoft date format
- Dieses Thema hat 2 Antworten sowie 2 Teilnehmer und wurde zuletzt vor vor 17 Jahren, 5 Monaten von Gwenvael Le Seach aktualisiert.
-
AutorBeiträge
-
April 30, 2007 um 6:18 pm Uhr #12636Gwenvael Le SeachTeilnehmer
I am currently using the demo version of Flexpro to analyse large sets of data from a fast recorder. It seems to be very powerfull and meet my expectations.
I still have a problem of date format. The fast recorder generate date in a “Microsoft” format, in days since the 1st of january 1900 (today is the 39202nd day. How can I use Flexpro to change that?Thanks
April 30, 2007 um 6:18 pm Uhr #8299Gwenvael Le SeachTeilnehmerI am currently using the demo version of Flexpro to analyse large sets of data from a fast recorder. It seems to be very powerfull and meet my expectations.
I still have a problem of date format. The fast recorder generate date in a “Microsoft” format, in days since the 1st of january 1900 (today is the 39202nd day. How can I use Flexpro to change that?Thanks
Mai 2, 2007 um 7:20 pm Uhr #9033Bernhard KantzTeilnehmerThere is no special function which converts your format into the calendar time format.
In FlexPro the calendar time value specifies the amount of time passed in seconds since January 1, 1970 at 00:00:00 UTC.
But you can create a VBA macro which converts the integer value into the calendar time format. It’s also possible to implement a custom import filter.Use the Date data type.
Example:Dim nDate As Long Dim dtmDate As Date nDate = 39203 dtmDate = nDate Dim oDataset As DataSet ThisDatabase.RootFolder.Add "Test", fpObjectTypeDataSet Set oDataset = ThisDatabase.RootFolder.Object("Test") With oDataset .DataStructure = fpDataStructureScalar .DataType(fpDataComponentY) = fpDataTypeCalendarTime .Value(fpDataComponentY) = dtmDate End With
See also
Automating Tasks
Automating Using FlexPro Visual Basic
Examples
A Custom Import Filter -
AutorBeiträge
- Du musst angemeldet sein, um auf dieses Thema antworten zu können.