Login or Sign Up
- Logging in...
  
  Remember me
  
  Or
  
  Sign Up
  
  Forgot password or user name?
- Log in with

Search in titles only Search in posts by fin2012 only

Advanced Search

Forums
Product Launch
Updates

Today's Posts
Member List
Calendar

Home
fin2012

User Profile

Collapse

Profile Sidebar

Collapse

fin2012

Last Activity: Jan 7 '16, 07:01 PM

Joined: Oct 26 '15

Location:

Subscriptions1
Subscribers0

Activities
About
Media
Subscribed

Time

All Time Today Last Week Last Month
Show

All Discussions only Photos only Videos only Links only Polls only Events only
Source

All fin2012 only Visitor Messages Only Advanced

Filtered by:

new posts

fin2012 replied to If DateSold is null then use Date() in workday function

in Access

Nov 4 '15, 10:13 PM
I like the Nz suggestion, much neater. Thanks for that NeoPa.

See more | Go to post
Leave a comment:
fin2012 replied to If DateSold is null then use Date() in workday function

in Access

Nov 4 '15, 10:12 PM
Thank you Rabbit for the solution.

See more | Go to post
Leave a comment:
fin2012 started a topic If DateSold is null then use Date() in workday function

in Access

Oct 26 '15, 07:53 PM
If DateSold is null then use Date() in workday function
I have two query expressions which works separately:
Days1:

Code:

IIf(IsNull([DateSold]),Date()-[DateBuy],Workdays([DateBuy],[DateSold]))

Day4:

Code:

Workdays([DateBuy],Date())

but when combined it does not work - too many arguments:

Days5:

Code:

IIf((IsNull([DateSold]),Workdays([DateBuy],Date()),Workdays([DateBuy],[DateSold])))

what is the solution please?
See more | Go to post

Last edited by zmbd; Nov 5 '15, 06:23 AM. Reason: [z{placed code format}]

No activity results to display

Show More

Bytes
Help
Contact Us
Privacy
Terms of Service
Go to top

All times are GMT. This page was generated at 1 minute ago.

Working...

👍

👎

☕