Forum Discussion
DATEADD doesn't allow duplicates?
Hey Community, I have a question that might be beyond basic but its got me and I can't find anything here or on google. When I try and use dateadd on a column any duplicate value returned is...
Hi Anonymous ,
By my tests and research, I'm afraid that your scenario is not caused by duplicate date.
Based on this document, which has mentioned that the result table includes only dates that exist in the dates column.
For your scenario, you may could create a canlendar table and then use DATEADD function.
Best Regards,
Cherry
Hi Anonymous ,
By my tests and research, I'm afraid that your scenario is not caused by duplicate date.
Based on this document, which has mentioned that the result table includes only dates that exist in the dates column.
For your scenario, you may could create a canlendar table and then use DATEADD function.
Best Regards,
Cherry
- "The result table includes only dates that exist in the dates column." Yeah, I didn't really understand what this meant but it's the cause of the error I am having. So it is working as advertised, just disappointingly so. Thank you for taking the time to review my issue and reply back!