nychaa.blogg.se

That means, date in yyyymmdd format and time in hhmmss format. I have requirement to provide the report in up-loadable date and time format.

Like in formula editor you will find in “ Year” which will return year in a Date, “ MonthNumberOfYear” it will return the number in a date, “ DayNumberOfYear” returns the day number in a year etc. Apart form this we may have date and time functions in formula editor which we can use according to usage to achieve desire format. These are some standard formula which we can use to get the desire format. Please see the below usage of Format for more understanding : Input dateįormatDate(datefield() “Dddd dd Mmmm yyyy” )įormatDate(datefield() “dd/MM/yyyy hh:mm:ss” )įormatDate(datefield() “dd/MM/yyyy hh:mm:ss a” )įormatDate(datefield() “dd/MM/yyyy HH:mm:ss”) Please note that it is case sensitive so it will make a difference if you write Ddd and DDD. There are some date format which are available in Webi. In Webi there are multiple way in which you can change the format of the displayed date and time field according to requirement.