![]() ![]() To add 45 days to an existing date I can create a calculated field. And what I want to do is to calculate a time 45 days in the future where we would expect a reply. In the scenario that I have envisioned here in the workbook, I'm assuming that clients have contacted my hotel about hosting a conference and we have a proposal required date that I've already filled in. Let's say that you want to add 45 days to a date. My sample file is the AddDates workbook, and you can find it in the chapter four folder of your exercise files collection. As Tableau counts Sunday as day 1 in its weekday calculations, we need to subtract 1 from our weekday calculation on our final date day2 for the final week. I'll show you several ways to perform those tasks. Calculating long strings of dates by hand can be cumbersome, so Tableau allows you to make the calculation easier by creating a formula to add a set interval or increment to a date. I have also set the format for the calculated field to custom with hh:mm AM/PM. ![]() example is subtracting 7 hours from 7/2/20 12:37:34 so the new date time will be 7/1/20 5:37:34. I am attempting this by writing the following in a calculated field: DATEDIFFminute,end time, start time). How to subtract 7 hours from a date time I'm trying to figure out how to write a calculation to subtract 7 hours from a date time field. In some cases, events can happen every eight or 10 days, or a client might have 45 days to respond to a proposal. I am trying to subtract a start time from an end time. Many events happen at regular intervals, such as every week, month, or year. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |