Konsta Danyliuk
- Total activity 601
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 273
Comments
Recent activity by Konsta Danyliuk-
Hello Chandra.Here is the method I could offer. Convert ReportingDate and PaidOffDate columns from string to date using the formula ASDATE(#<ColumnName>; "dd-MMM-yyyy"). Find the difference betwe...
-
Hello Mario.Thank you for additional clarification on the use-case. I was not able to reproduce any unexpected behavior playing with these formulas in my lab. Were you able to completely resolve th...
-
Hello Mario.What was the initial problem with this formula, did it return an error or an incorrect result? If there was an error, would you be able to provide the screenshot, please? Your formula w...
-
Hello Mario.If I properly understand the requirements, you have the following initial dataset with column types INT, INT, INT, DATE, STRING, and STRING respectively. I believe the following formul...
-
Hello Mario.I guess it is also possible to perform a similar calculation without TIMESTAMPDIFF, using TIMESTAMP and MOD functions. To determine number of days between two date values: Convert both...
-
Hello Kang.To subtract one date field from another you could leverage TIMESTAMPDIFF function. It returns the number of whole date intervals between two date arguments.Example1. Get the time differe...
-
Hello Kang.Thank you for the additional details. In a SQL Worksheet, you could use CURRENT_DATE and INTERVAL functions to achieve the desired goal. SELECT Sheet.Column FROM Sheet WHERE CAST(Sheet.C...
-
Hello Elwyn.I hope you are doing well. I've just tried reproducing this behavior in my lab but can't. What Dataneer version do you have? Would you see the difference of 40 or 41 seconds if you crea...
-
Hello Chandra.You probably could: Get the month number from the PaidOffDate value via MONTH(#PaidOffDate) Sum up #PaidOffDateMonth and #ExplodeRange. As ExplodeRange value is incremental within a...
-
Hello Chandra.Would you mind providing a sample or the source data (Reporting Date, Paid off Date) and the result you are looking for? E.g., a mock-up in Excel. This helps us to understand the desi...