PQDate(Object, Boolean) Method

Creates a powerquery compliant #date function from excel date type value
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)

Syntax

public static string PQDate(
	object DatePart,
	bool forceDateTime
	)

Parameters

DatePart
Type: Object
date/time/datetime single parameter or range reference
forceDateTime
Type: Boolean

Returns

String
the powerquery #date function