Date time Query

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

Data Investigation

Accepted answers

Here is how you can do it.

Workflow:

Hope this helps : )

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

Hope this helps,

M.

mceleavey_solution.yxmd

All comments

Here is how you can do it.

Workflow:

Hope this helps : )

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

Hope this helps,

M.

mceleavey_solution.yxmd

Thank you soo Much this works for me

Thank you so much works well for me

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703