create date with only month and year

**kwooten** · 05-12-2015, 08:41 AM

I have a report that has only month and year but need to create a date format from it; so January 2014 should be 1/1/2014 or 1/31/2014 (I dont care which).. any way to do this?

**JoeM** · 05-12-2015, 08:46 AM

I am not sure I understand. Reports are not editable, no data can be entered via a report.
So where exactly is this month/year coming from?

**kwooten** · 05-12-2015, 08:51 AM

sorry... I have a table with only month and year...

**JoeM** · 05-12-2015, 09:02 AM

Try this calculated field:
MyDate: DateValue([MonthField] & " 1, " & [YearField])

**kwooten** · 05-12-2015, 09:58 AM

will that create a field that I can run a datediff against?

**JoeM** · 05-12-2015, 10:01 AM

It will create a Calculated Field that is in Date format, so yes, you will be able to run Date functions like DateDiff against it.

create date with only month and year

Thread Tools

create date with only month and year

Similar Threads

Trying to create a Report using 2 comboboxes with Month and Year

Create month end date, from Month(Numberic) and Year(Numeric)

Month and Day only not Year to create query

Year to DATE by Month

month year date

Posting Permissions