Display dates in a month as the first day of the month

[TyeReece]

Probably an easy question, but I have a date field in a query that I want to display as the first day of the month for each record so that when I export to excel all the dates for November will show as 11/1/2017 etc. any help is appreciated.

 

[sungersoo]

=a1-day(a1)+1

 

[TyeReece]

Is this an excel formula? I wanted to convert it in access if I could to save the step.

 

[FDibbins]

I don't know access well, but this is how I would do it in excel...
=EOMONTH(date-field,-1)+1

I know some functions are similar, perhaps that will get you started?

 

[TyeReece]

I will try that. Thank you!

 

[welshgasman]

ExportDate:Dateserial(Year(YourDate),Month(YourDate),1)

HTH

 

[TyeReece]

Perfect. That is it. Thx welshgasman.