Why unknown file types are not served by IIS

Here is the command:

%windir%\system32\inetsrv\appcmd set config /section:staticContent /+"[fileExtension='.3gp',mimeType='video/3gpp']"

And while we are at it. You might run into the same problem with MP4 files. Here is the appcmd for it:

%windir%\system32\inetsrv\appcmd set config /section:staticContent /+"[fileExtension='.mp4',mimeType='video/mpeg']"

Get Week Day No and Name in Crystal Report

First Get WeekDay No using this function

WeekDay ({DateGoesHere}, firstDayOfWeek) 

date(DateTime): Any valid date, 
firstDayOfWeek(int): Possible Values[crMonday, crTuesday, crWednesday, crThursday, crFirday, crSaturday, crSunday]: Default crSunday
Then use

WeekDayName(WeekDay ({DateGoesHere}, firstDayOfWeek), false, firstDayOfWeek)