Date Format

[Andy1120]

Hi Support
I have a question about the date format.I want to format a date that format style is yyyy-mm-dd,I write like below ,bu it's get error.
{IIF(IsNull(datesource,"billdate"),Year(datesource.billdate)-IIF(Month(datesource.billdate)<10,"0","")Month(datesource.billdate)-IIF(Day(datesource.billdate)<10,"0","")Day(datesource.billdate),"")},Can you provider simple way to format a date?
Thank you
BestWishes

[HighAley]

Hello.

Please, try to use Text Format property to set Date Format.

Thank you.

[Andy1120]

Thank you for your reply.

[Andrew]

Hello,

That would be great if you could let us know whether this advice does help you.

[Andy1120]

Thank you for your reply.you had told me to use customer format.it worke well.thank you

[HighAley]

Hello.

We are always glad to help you.
Let us know if you need any additional help.

Thank you.