date

[Dolly123]

convert

I want this field to be like dd/mm/yyyy

[Mark_Little]

Hi @Dolly123 

Try

DATE(Date#('01-'&[Month - Year], 'DD-MMM-YYYY']),'DD/MM/YYYY')

[Dolly123]

 error check herre

[Dolly123]

error plz resolve waiting for reply

[RsQK]

Try like this:

DATE(DATE#("Month - Year",'MMM-YYYY'),'DD/MM/YYYY') AS Datefield

[Dolly123]

you know concept of makedate

[RsQK]

What did you mean by that?
With the line I pasted, I am getting this result:

If the field isn't exactly text and you still want each value to be like "01/MM/YYYY", you can try:

DATE(MONTHSTART(DATE#("Month - Year",'MMM-YYYY')),'DD/MM/YYYY') AS Datefield

[Dolly123]

thanks

[Dolly123]

can u explain me this i am not getting