I have everything on the form working correctly except for Days Late - the value displays as #Type! . The control source is =Date()-[DueDate], Format is blank. I am using the subscription version of Office 365. I have tried changing the Format to General Number but the result is the same. What could my problem be?
Scott Axton
@Reply 5 years ago
Did you double check that DueDate in the table is set to Date/Time data type?
Adam Schwanz
@Reply 5 years ago
You wouldn't want general number, it's a date field. Like Scott said check in your table that it's set to Date/Time.
If it is, you might have something weird going on.
You can try =Date()-CDate(DueDate) just to confirm it works. But that's not the ideal solution, would need to find and fix the problem.
Larry LargeOP
@Reply 5 years ago
Thanks guys! The DueDate was set to short text. I changed it to Date/Time and now everything works correctly.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.
