Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Educator-Ambassador
Educator-Ambassador

Date format in formula

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

2 Replies
imrasyed
Creator II
Creator II

Try something like this 

 

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

 

 

jerryr125
Educator-Ambassador
Educator-Ambassador
Author

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 ?