MonthStart and MonthEnd Dates as YYYYMMDD format from dd/mm/yyy

[Peter_Brunner]

Hi All,

I have been trying to format a date and remove seperators but no joy  YYYYMMDD

Not DD/MM/YYYY

I have attached a sample files to explain  

appreciate any help

Reagrds Peter

[BrunPierre · Accepted solution]

Try:

Date(MonthStart(TempDate), 'YYYYMMDD') as MonthStartDateNum,
Date(MonthStart(TempDate), 'YYYYMMDD') as MonthEndDateNum

[Peter_Brunner]

Hi 

you are Correct  had to change the MonthEnd date to the second statement but all good works as I require 20161201 20161231

Date(MonthStart(TempDate),'YYYYMMDD')as MonthStartDateNum

Date(MonthEnd(TempDate),'YYYYMMDD')as MonthEndDateNum

thank you

Regards Peter