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
Solved! Go to Solution.
Try this formula (it means filter when 202212 = 202212 basically)
datetimeformat([kdate], "%Y%m") = DateTimeFormat(DateTimeAdd(DateTimeToday(), -1, "months"), "%Y%m")
@chiragpatel_1 One way of doing this
[kdate] >= toDate(DateTimeTrim(DateTimeAdd(DateTimeToday(),-1,'month'),'firstofmonth') )
AND
[kdate] <=
toDate(DateTimeTrim(DateTimeAdd(DateTimeToday(),-1,'month'),'lastofmonth') )