topic Re: Date format in formula in App Development

Date format in formula

jerryr125 — Tue, 11 Jun 2019 11:44:17 GMT

Hi -

I have the following statement :

=if( IsNull(GetFieldSelections(DATE)),' ',[DATE.autoCalendar.Date] )

When the selection is not null, it displays the date as a number. How do I modify the formula above to display the date as WWW - MMM/DD/YYYY ??

Thanks - jerry

imrasyed — Tue, 11 Jun 2019 13:23:23 GMT

Try something like this

=week(today()) & ' - ' & Date(Today(),'MMM/DD/YYYY')

jerryr125 — Tue, 11 Jun 2019 13:34:59 GMT

If this is the formula - what do I add to get the date to change to DDD - MMM/DD/YYYY ???

=if( IsNull(GetFieldSelections(DATE)),' ',[DATE.autoCalendar.Date] )

thoughts ?