Skip to main content
SUBMITTED

Other increments of time ahead than days when creating a date table

Related products:TimeXtender Data Integration
  • January 18, 2023
  • 1 reply
  • 28 views

anders.e.jonsson
Contributor
Forum|alt.badge.img+1

It would be useful if it was possible to add Years or months ahead when creating a date table. Years ahead is particularly useful when working with financial data. Days ahead will always produce a number of days into a superfluous year.

 

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • January 18, 2023

It would indeed be nice to have the regular SQL Dateparts as option for the items ahead. This avoids strange bounds in leapyears.