date()

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

I a query i would like to use the below check. I can't figure out why it
doesn't work.

MyAnnouncement: IIf(Format(Announcementdate;"Short
Date")>date();Announcement;"")

Thanx for any tips

Regards,

Harmannus
 
It's because you need to replace the semi-colons with
commas - it should read:

MyAnnouncement: IIf(Format(Announcementdate,"Short
 
Harmannus

From your expression, you are trying to compare a format with a date -- why
not just compare dates? By the way, does your [AnnouncementDate] field
contain both date AND time, or just date (with the time info as "00:00...")?
 
Hallo,

Thanx for the reply.

I contains the date without time!

Regards,
Harmannus
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Start query from 01-01-year(date() 2
Data of Birth to Birthday 1
Address subform in a query 3
Sorting 2
Birthdays week, month, year? 4
Remove spaces from field? 2
Adressing subform in Query 2
Calculated Field in Query - Date Format 5

Back
Top