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