Solved

Cloud Workflow Query List Date and Time Field

  • 20 August 2021
  • 5 replies
  • 148 views
A
Badge +4

Hi I am creating a workflow using a scheduled event and querying a list. So basically at 1100pm I want nintex to query a list using a date and time column (in sharepoint i don't use the time just date) then use a run if function that is if the column date is equal to the context date then it send an email. However even though I select sharepoint to use just the date it appears to still add the time from the query date. See attachment. Any help would be appreciated19330iF284CBBA3569AC3B.png

19331i7A59DCF6D12C837C.png

19329i3A6C114EC258D496.png

   

. 

icon

Best answer by butlerj 23 August 2021, 18:30

View original

5 replies

L
Userlevel 5
Badge +13

@Andrew87 Date/time fields always have time it is just hidden when selecting date only. It will be set to midnight for the local time zone in SharePoint. You could potentially look at using a range if you deal with multiple time zones, otherwise do the condition against midnight. 

A
Badge +4

I don't have to worry about time zones. How would I go about formatting the current date and midnight??


 



 

butlerj
Userlevel 5
Badge +19

@Andrew87 given that all date/time values from SPO come back in Zulu time you should be able to use the 'Current date' context variable and append T00:00:00Z to set things to midnight. For example:





 


Hope that helps.


 

A
Badge +4

Awesome Thank you!

A
Badge +4

I'd like to send an email notification for each result with information from the list in it or one email with all the queried information in it. Any thoughts on how i could accomplish this?

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings