Calculate remaining days in the month

[cstafford]

Looking for ways to streamline a process to calculate the remaining days in the current month within Alteryx. I know how to do it mathematically, but with all the features in Alteryx, I am guessing their might be a more efficient way? Look for ideas or best practice.

[apathetichell]

fyi - datetimelastofmonth() - only gives the last day of the current month.

DateTimeTrim([insert your date field here], 'lastofmonth') as referenced by @Felipe_Ribeir0 originally is more flexible since it will provide you the last day of any month based upon your date field or of the current month.

[sshutchinson]

Hello,

I have a question kinda similar to this example. In my data set I have data from Dec. 1-28th in column header "Date". Because there are 31 days in Dec., I need to estimate the rest of the data for the following dates: 29th, 30th, and 31st. To do so, I want to use a 7 day lookback. By that I mean, the 29th will use data from the 22nd. The 30th will use the data from the 23rd. The 31st will use data from the 24th.