Help with Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the function as copied from sql view

IIf(([dbo_Pr_EmpJobData_T]![dteEndRateDate]=9/9/9999),"
",[dbo_Pr_EmpJobData_T]![dteEndRateDate])

What I am trying to do is if the date shows 9/9/9999 in the EndRateDate
field then show nothing but if it is anything other than 9/9/9999 show me the
date in that same field.

When I run this all the dates show nothing. help?
 
You forgot the date delimiter of "#". And I would return Null rather that
a string, so if you want to sort by dteEndRateDate you will get a date order
sort instead of a string order sort.

IIf([dbo_Pr_EmpJobData_T].[dteEndRateDate]=#9/9/9999#,
Null,[dbo_Pr_EmpJobData_T].[dteEndRateDate])
 

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

Function help please 3
IIF statement in query calculated field 5
Report based on multiple query's 3
Access DateDiff function 0
Query Help 1
Problems with AND in multiple IIF statements 5
Check previous record when promote 2
Grouping/Deleting Dates/Times (HELP ANYONE!) 2

Back
Top