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...")?
 
Back
Top