Show Month as "99/99/0000" based on Year

Hi again

This is an example:

Year | Month
2014 | Jan
2014 | Jan
2015 | Feb
2016 | Mart
2014 | Feb

So in Column "Month" I need to switch the Month like

Year | Mont
2014 | 1/1/2014
2014 | 1/1/2014
2015 | 2/1/2015
2016 | 3/1/2016
2014 | 2/1/2014

Can someone help me? :-D

Thanks.

Originally Posted by FDibbins

Is this access or excel?

This is Access

Originally Posted by alansidman

Assume your field names are dYear for the Year column, dMonth for the month column then in a query to create the dates you wish

PHP Code: 

SELECT tbldates.dYear, tbldates.dMonth, DateSerial([dYear],Switch([dMonth]="Jan",1,[dMonth]="Feb",2,[dMonth]="Mar",3,[dMonth]="Apr",4,[dMonth]="May",5,[dMonth]="Jun",6,[dMonth]="Jul",7,[dMonth]="Aug",8,[dMonth]="Sep",9,[dMonth]="Oct",10,[dMonth]="Nov",11,[dMonth]="Dec",12),1) AS sMonth
FROM tbldates; 


This will put the dates in a new field called sMonth. You can then hide your field dMonth by unchecking the display check box in your QBE.

This works perfectly!
Thank you!