I want a column that generates value like this:
9/7/2014 12:00:00AM
9/7/2014 1:00:00PM
9/7/2014 2:00:00PM....
till
9/13/2014 12:00 AM, How to achieve this?.
1 answer
not certain what you are trying to accomplish from the question
what are describing sounds like you want to create a hourly calendar but the data you have is just two independent dates - that's a variation of the 2 date problem which can be solved with the use of a scaffold . see https://jimdehner2.blogspot.com/2021/02/faq-series-when-and-how-to-scaffold-data.html the first example
Jim
