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
Hi @chiragpatel_1
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') )
