Get last or previous month SharePoint list items

(0) Share

Report

Posted on by rameshmukka

1,115

Hello Power Addicts,

I am trying to get all SharePoint list items whose "MyDate" column is having any date of previous month. I am using below filter query in Get Items action.

MyDate ge '@{startOfMonth(getPastTime(1,'Month'))}' and MyDate lt '@{startOfMonth(utcNow())}'

I dont know why but I dont get items dated 1st of previous month and I also get items dated 1st of current month. Both these cases shouldn't happen. My SharePoint site is in IST time zone. Should that be a problem as flow can understand only UTC. How should my filter query look like?

Thanks,

Ramesh

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello @RameshMukka ,

I suppose the timezone could be the problem, the difference of 5 hours and 30 minutes could move the date to another day. You could try to convert the output from getPastTime(...) and utcNow(...) into the IST time zone with the convertFromUtc(...) expression:

e.g. convertFromUtc(utcNow(),'India Standard Time') MyDate ge '@{convertFromUtc(startOfMonth(getPastTime(1,'Month')),'India Standard Time')}' and MyDate lt '@{convertFromUtc(startOfMonth(utcNow()),'India Standard Time')}'

Was this reply helpful? Yes No
Verified answer

rameshmukka 1,115 on at

Like (2)

Report
Copy link

Link copied!
Below expression solved the problem
MyDate ge 'formatDateTime(startOfMonth(getPastTime(1,'Month')),'MM-dd-yyyy')' and MyDate lt 'formatDateTime(startOfMonth(utcNow()),'MM-dd-yyyy')'

Was this reply helpful? Yes No