ISO8601 Date in a IIF Statement

[monkeyman]

Hello,

I need a field in a query to show todays date and a date 10 days from now in ISO8601 format like this:



2011-03-01T13:00:00Z/2011-03-11T15:30:00Z

It should only display when another field is "true". Here's what I have so far and it's incomplete:

sale price effective date: IIf([inventory]![SaleOn]=Yes,Date())Format [sale price effective date], "yyyy-mm-dd"))

Can anyone help me put the finishing touches on this or tell me if I'm barking up the wrong tree with this approach?

Thanks!

[June7]

Looks like circular reference, could be a problem. Try:
sale price effective date: IIf([inventory]![SaleOn]=Yes, Format(Now(),"yyyy-mm-ddThh:nn:ssZ") & "/" & Format(Now()+10, "yyyy-mm-ddThh:nn:ssZ"), Null)

[monkeyman]

Excellent, that worked like a charm, thanks!