FormatDate() Help Document

harish17

Active Member
Hi EveryOne,
For FormatDate() as Per The help Document (HelpDocument mean When You open the Calculation Stage Click Question MArk it will redirect to Help Document > Studio>StudioUsage>Calculations and Decisions )it is saying

FormatDate("02-11-2016 09:23:43", "t") will return "09:23" As per help document But it is returning 12:00 Am for me.

FormatDate("02 Nov 2016 09:23:43","F") will return "02 November 2016 09:23:43" but it is Returning Wednesday November 2016 12:00:00 Am

please Correct me is it working as design or is there a mistake in Help document?
 
Last edited:

VJR

Well-Known Member
Hi EveryOne,
For FormatDate() as Per The help Document (HelpDocument mean When You open the Calculation Stage Click Question MArk it will redirect to Help Document > Studio>StudioUsage>Calculations and Decisions )it is saying

FormatDate("02-11-2016 09:23:43", "t") will return "09:23" As per help document But it is returning 12:00 Am for me.

FormatDate("02 Nov 2016 09:23:43","F") will return "02 November 2016 09:23:43" but it is Returning Wednesday November 2016 12:00:00 Am

please Correct me is it working as design or is there a mistake in Help document?
Use customised formats such as the one in bold
Expression: FormatDate("02 Nov 2016 09:23:43","dd/MM/yy")
Result: 02/11/16
 
Top