formatPQDate(Double, Boolean) Method

takes an OADate and formats it as a powerquery compliant #date, #time or #datetime function
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

private static string formatPQDate(
	double datVal,
	bool forceDateTime
	)

Parameters

datVal
Type: Double
OADate (double) date parameter
forceDateTime
Type: Boolean

Returns

String
powerquery function