Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I have this done?

Status
Not open for further replies.
ajayz90

ajayz90

Programmer
Nov 12, 2002
65
0
0
US
I want to compare two dates startdate and enddate and is the date protion of the two is the same display just the end time for the end date else display the end date and the end time for the end date.


Thanks In anticipation.

Ajay
 
Sort by date Sort by votes
IF DateValue(StartDate) = DateValue(EndDate) THEN
Time(EndDate)
ELSE
DateTime(EndDate) //same as EndDate
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
86
Brian S
Brian S
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
98
SarahSCPDAdmin
SarahSCPDAdmin
AleXSR700
  • Locked
  • Question
How can I make variable that is re-defined per section and readable in same-section formula? 2
2
Replies
20
Views
264
AleXSR700
AleXSR700
AleXSR700
  • Locked
  • Question
How to find first non-zero decimal place?
Replies
8
Views
104
AleXSR700
AleXSR700
wantj43
  • Locked
  • Question
I have an Access 2016 form that con
Replies
1
Views
47
pmax9999
pmax9999

Part and Inventory Search

Sponsor

Back
Top