-
FlexPro
- Zoom sur FlexPro
- Fonctionnalités & Options
- Domaines d’application
- Tous les avantages
- Nouveau dans FlexPro 2021
- Testez FlexPro gratuitement
- FlexPro View OEM Freeware
- Conseils d’achat
- Login
- Langue
- +49 6894 929600
- infoweisang.com
- Google Maps
- Produits
- News
- Support
- Société
- Emplois
- Contact
- Login
- Langue
- +49 6894 929600
- infoweisang.com
- Google Maps
Accueil > Community > General > Microsoft date format > Reply To: Microsoft date format
May 2, 2007 at 7:20 pm
#9033
Bernhard Kantz
Participant
There 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