×
Menu
Index
Search
 
   
   
   
 
© Copyright 2020 NAVISYS - All Rights Reserved    
email: sales@navsherpa.com | phone: +420 515 551 200

Formats (FastTab)

Formats are used to convert text into variables and variables into text. For example, if the text is a number, the text can be converted to a decimal number.
Formats (FastTab)
1

Thousand Separator

1. Thousand Separator    
Specifies the thousand separator.
2

Decimal Separator

2. Decimal Separator
Specifies the decimal point.
3

Precision

3. Precision
Specifies the number rounding and maximum decimal places.
4

DateTime Format

4. DateTime Format
Specifies the parts and order for date and time.
5

Date Separator

5. Date Separator
Specifies the separator between days, months and years.
6

Time Format

6. Time Format    
Specifies the components and ordering of times.
7

Date Format

7. Date Format
Specifies the components and ordering of dates.
8

Date as DateTime

8. Date as DateTime
Specifies whether to convert dates to date and time.
 
Example:
Microsoft Dynamics NAV saves dates and times in separate fields but SharePoint needs a date and time => The date field has to be converted from NAV date to date and time.
9

Time as DateTime

9. Time as DateTime
Specifies whether to convert times to date and time.
 
Example:
Microsoft Dynamics NAV saves dates and times in separate fields but SharePoint needs a date and time => The time field has to be converted from NAV time to date and time.
10

Use UTC For DateTime

10. Use UTC For DateTime
Specifies whether to use UTC date and time for communication with SharePoint.
11

Use Daylight Saving Time

11. Use Daylight Saving Time
Specifies whether to work with daylight saving time when exporting/importing date and time fields.
12

Boolean Format

12. Boolean Format
Specifies the format for boolean fields.
13

Duration Format

13. Duration Format
Specifies the format for duration fields.
14

Option Format

14. Option Format    
Specifies the format for option fields.
15

Time Separator

15. Time Separator
Specifies the separator between hours, minutes and seconds.
16

Date Time Separator

16. Date Time Separator
Specifies the separator between dates and times.
17

Date Time Millisecond Separator

17. Date Time Millisecond Separator
Specifies the separator for milliseconds.