Page 1 of 1

Date Format

Posted: Mon Oct 27, 2014 2:31 am
by 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

Re: Date Format

Posted: Mon Oct 27, 2014 8:38 am
by HighAley
Hello.

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

Thank you.

Re: Date Format

Posted: Tue Oct 28, 2014 7:19 am
by Andy1120
Thank you for your reply.

Re: Date Format

Posted: Tue Oct 28, 2014 8:28 am
by Andrew
Hello,

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

Re: Date Format

Posted: Wed Oct 29, 2014 2:06 am
by Andy1120
Thank you for your reply.you had told me to use customer format.it worke well.thank you

Re: Date Format

Posted: Wed Oct 29, 2014 7:47 am
by HighAley
Hello.

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

Thank you.