0

Time from navision is Timedate in Excel

Jet Reports Historic Posts

November 01, 2016 11:02

None

Follow

Hi

I have an issue with reading times from a NAV database. The original data in the database is shown as regular time data, but when i create a JetReport and load the data from the same table, Excel shows my times as Datetimes.

Is this a setup in JetReports I'm missing?

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts November 02, 2016 07:43

  Can you not just format it to show only the time?

• 0
  
  Jet Reports Historic Posts November 07, 2016 10:40

  Can you not just format it to show only the time?

  
  My issue is that i need the time to work in a formula with a date from another column in my spreadsheet.
  Otherwise your solution would have worked.
• 0
  
  Jet Reports Historic Posts November 07, 2016 12:07

  Can you give the formulas you're working with?
  
  While it may be a problem with Jet Reports that needs fixing, we might be able to sort you out a workaround.

• 0
  
  Jet Reports Historic Posts November 07, 2016 14:14

  Can you convert the result of the JET formula with an excel formula?
  
  Example: Jet Output in D4 = 01/01/16 10:45
  Excel Helper formula in E4 = TIME(HOUR(D4),MINUTE(D4),SECOND(D4))
  
  Then point your other formula to the helper column, not the date/time column.