Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
convert
I want this field to be like dd/mm/yyyy
error check herre
error plz resolve waiting for reply
Try like this:
DATE(DATE#("Month - Year",'MMM-YYYY'),'DD/MM/YYYY') AS Datefield
you know concept of makedate
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
thanks
can u explain me this i am not getting