ChristopherAngu
Qrew Member
Joined 3 years ago
User Profile
User Widgets
Contributions
Jinja Json Object in Pipeline
Good morning, In one of our pipelines we need to make a POST request to business central in order to get the access token needed to created a GET request. I'm having difficulties using jinja to filter my contents response to the just the access token itself to use for my second step. Could anyone help me regarding this? ------------------------------ Christopher Angulo ------------------------------46Views0likes2CommentsFormula to Calculate EST. Exhaustion Date
Hello I'm currently trying to calculate what would be our "Estimated Exhaustion Date" of service provided to our customers. Currently within our excel spreadsheet that we are converting to QB, we have a field that takes the information from another field labeled as "Months Coverage Remaining" which is a number field that contains data of how many months remain of active coverage for our customers, that information is then added to today's date in order to calculate the Estimated Date we are to stop service. The issue i'm running into is the "Months Coverage Remaining", is a number field and doesn't allow me to add it to a date. Is there anything that could convert said number field to a date to complete the formula? Or what would be the best option to go about this calculation? Thank you for all your hard work! ------------------------------ Christopher Angulo ------------------------------13Views0likes2CommentsRe: Formula to display time billed in months not day
Thank you for the quick response I really appreciate it. And my apologies for not explaining it too well. So my "date" field gets dates imported through CSV files which are the dates that our service began to our customers. In the spreadsheet we currently have a formula that takes the date of which service started and displays how many months have passed based on todays date since our service started to said customer. So I was trying to find a way to display the duration that has passed between the date field we enter and today's date in months. I was able to calculate the amount of days not months. Thank you! ------------------------------ Christopher Angulo ------------------------------13Views0likes3CommentsFormula to display time billed in months not day
Hello, I'm trying to create a formula that will take the date entered within field in my application named, "Date", and the current date and display the amount of time between the two in months not days. I used ToDays(Today()-ToDate([Date])) which returned the value within days. Thank you for your help in advance. ------------------------------ Christopher Angulo ------------------------------10Views0likes5Comments