Formula tool Date rang

Question

Hi community,

i would highly appreciate some help with my issue

i am trying to use a formula tool to calculate the period of six months prior to the date in my input file

so the input file date is june 30 2024, and i need the formula tool to calculate it back to jan 1 2024, and so on for dec

is there a way to do that?

Raj · Answer

@Basma_alrubaish 
this will work
datetimeformat(DateTimeTrim(DateTimeAdd(DateTimeparse([Date],"%B %d %Y"), -5,'months'), 'month'),"%B %d %Y")

Basma_alrubaish · Answer

is there a way i can use the same initial formula but have the start date fixed as the first date of the month?

DateTimeAdd([Period start], -6, 'months')

Raj · Answer

@Basma_alrubaish 
find workflow attached for reference

3185.yxmd