Hello,
I want to calculate the end of month for a whole year. How can I do this?
Thanks
Solved! Go to Solution.
datetimetrim(). Is your friend:
DateTimeTrim(dt,t)
Remove unwanted portions of a date/time and return the modified date/time.
dt: Date/time data, expressed as a selected column or a specified date/time value between quotes.
t: Trim type. Options include:
cheers,
mark
Hi @Ecaterina ,
you could use DateTime functions (DateTimeParse, DateTimeAdd) combined with Generate Rows tool to create a list of EOM dates. I've attached a sample workflow.
Best,
Roland
Thanks. it is work well
Look at these functions:
DateTimeLastOfMonth()
DateTimeFirstOfMonth() - then subtract one day
Use the Generate Rows tool
In this post:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-drop-down-list-boxs-to-populate-...
there is a macro that calculates many common dates like:
period
year
day
first day of month
last day of month
isWithin5DaysOfClose
isWithin5DaysOfOpen
day of week text
isWeekday
isWeekend
day of week text short
day of year
month text
month text short
qtr_txt
qtr_num
isEndOfMonth
isFirstOfMonth
isClosingPeriod
isOpeningPeriod
weekOfYear