Date formatting not working . Help !

[shekhar_analyti]

Hi All ,

After long time i was trying to format date_of_sale field . But i was unable to . Due to which it is not integrating with Master calendar .

Although I have  tried Num , Date # combination as well . Need help .

Regards

Shekar

[shekhar_analyti]

I THINK I DID IT ..  THANKS

[sunny_talwar · Accepted solution]

Try this

Date(Date#(Date_of_sale,'D/M/YYYY')) AS DS,

[shekhar_analyti]

This worked for me too ;

Date#(Text(Date_of_sale),'DD/MM/YYYY')

[sunny_talwar]

Don't really need Text() as it is already a text