Date time Query

[Saagar]

I am trying to calculate Users that do not access the website for more than 180 days

I have 2 fields of data One with a creation date in this format 2010-07-19T06:55:26.860 and one with the Last access date in the same format 

Can someone please help me with this 

[atcodedog05 · Accepted solution]

Hi @Saagar 

Here is how you can do it.

Workflow:

Hope this helps : )

[mceleavey · Accepted solution]

Hi @Saagar ,

Simply convert the date and do a datetimediff() function:

Hope this helps,

M.

[Saagar]

Thank you soo Much this works for me :)

[Saagar]

Thank you so much works well for me

[atcodedog05]

Happy to help : ) @Saagar 

Cheers and have a nice day!

[mceleavey]