pulling previous month data

[chiragpatel_1]

hi,

I want to bring in previous moths data (December 2022) dynamically, and my data set does have previous months data but my formula which i have used many times dosent seem to work, the date is in the correct format.

format of my data,

many thanks

[Felipe_Ribeir0 · Accepted solution]

Hi @chiragpatel_1 

Try this formula (it means filter when 202212 = 202212 basically)

datetimeformat([kdate], "%Y%m") = DateTimeFormat(DateTimeAdd(DateTimeToday(), -1, "months"), "%Y%m")

[binuacs]

@chiragpatel_1 One way of doing this

[kdate] >= toDate(DateTimeTrim(DateTimeAdd(DateTimeToday(),-1,'month'),'firstofmonth') )
AND

[kdate] <=
toDate(DateTimeTrim(DateTimeAdd(DateTimeToday(),-1,'month'),'lastofmonth') )