Date Query Help

[Jovix]

Hello everyone, I have a column called DueDate in a query that contains dates. I want to populate a second column based on this DueDate but, if the date in DueDate is less than today, then set the DueDate to today. Make sense? Can someone share the line of code I need to enter into my new column.

Thanks in advance, G

 

[LNBruno]

Sounds like you need a conditional if statement (psuedo-code):

=IIf(DueDate < Today, Today, DueDate)

< M!ke >

 

[cghoga]

In a new column in your query enter the following:

NewDueDate: IIf([DueDate]<Now(),Format(Now(),&quot;mm/dd/yyyy&quot,[DueDate])

Hope this helps you.

 

[cghoga]

Sorry I wasn't too clear.

Enter this in the field area of a new column.

NewDueDate: IIf([DueDate]<Now(),Format(Now(),&quot;mm/dd/yyyy&quot,[DueDate])

hth

 

[Jovix]

thanks cghoga, it works great.

G