Formatting Date

P

pschoen

I have a line in my report to keep the From and To Dates from showing if the
From Date is null: =IIf([FromDate1] Is Null Or [ToDate1] Is
Null,Null,[FromDate1] & " to " & [ToDate1])

My question is, how do I include instructions for mmyyyy formatting in this
line?

Thanks
Phil
 

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

Getting rid of "to" when the date fields are null 4
Countdown macro - display settings 2
How do I filter a report to show only specific date 3
Blank lines in report 0
Removing Empty Line 5
VSTO C# add in Outlook.Appointment error 0
Conditional DB reports 3
Display weeks from a Milestone 0

Top