Its Date Func

[suby]

Hi All,

Any thoughts please.

From the above screenshot My Max Date time out is set to  ='30/04/2021' but when i do -1 months I'm expecting '31/03/2021'

From the above screenshot my date time out is set to 28-02-2021 but when i add i would expect 2021-03-31

[Luke_C]

Hi @suby 

This is due to how the datetimeadd function works. See this thread for more

If you want to get the last of the month, you could try wrapping your function in a datetimetrim:

DateTimeTrim(DateTimeAdd([DateTime_Out],1,'month'),'lastofmonth')

[suby]

Thank you so much Luke what happens if this 

My Max Date time out ( max on List of Dates) and that is  set to  ='30/04/2021' but when i do -1 months I'm expecting '31/03/2021'

[DawnDuong]

Hi @suby 

If what you want is to find the last day of the month there is a direct method here

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Find-The-Last-Day-Of-Any-Mon...

the syntax you use will only give the same “day” in a different month. Since month end varies 28-31, this syntax does not always give u the last day of the month.

dawn