textmode custom date | Community
Skip to main content
P
PollyCo
Level 9
February 25, 2020
Question

textmode custom date

  • February 25, 2020
  • 1 reply
  • 409 views

Hello,

I've been gone so long from the community, I feel like a noob now.

So .... I'm looking for all projects that has hours between 6 months ago (basically August 1, 2019 - October 31, 2019) and does not have hours between Nov 1, 2019 - January 31, 2020, plus a few other requirements related to the project.

Now, I can't do this with an hour report AFAIK, it won't generate anything with an hour null filter (so null entryDate Nov 1- Jan 31 does not work).

I thought I'd do a project report, showing actualHoursLastThreeMonths which is an actual field available in project reports which means I can filter out anything that has hours in it (covers Nov 1 - Jan 31). This would have been fine except I really want to see the total hours I have that's entered between Aug 1 - Oct 31 in the report. I thought about adding hour collection but I have not seen how to write specific dates if I decide to use IF.

eg IF(entrydate>Aug1), and so on so forth. What is August 1, 2019 in text mode?

Any other ideas on how I could possibly do this, even in another alternative way?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

P
PollyCoAuthor
Level 9
February 26, 2020
Answering my own regarding custom date on text mode: this would be 2019-11-01T00:00:00:000 I think. Still looking for simpler, alternate ways to get the hours? Polly Co
Terms & ConditionsAccessibility statement

Loading footer...