ADF expression

Question

hi,

do you see why I get this error which is inside the expression of a dataset?

@concat(
	dataset().p_url_path,'MOI-'
	,formatDateTime(dataset().p_CurrentDate,'dd')
	,'-'
	,iif(
		length(formatDateTime(dataset().p_CurrentDate,'MMMM')) > 3
		, formatDateTime(dataset().p_CurrentDate,'MMmM')
		, formatDateTime(dataset().p_CurrentDate,'MMM')
	)
	,'-'
	,formatDateTime(dataset().p_CurrentDate,'yyyy')
	,'.csv'
)

Answer 1

I think that ifdataset().p_CurrentDate is not in the date format or if it's null, formatDateTime will not be able to parse it, and that could be a source of error

Try the following :

@concat(
    dataset().p_url_path,'MOI-'
    ,formatDateTime(dataset().p_CurrentDate,'dd')
    ,'-'
    ,iif(
        length(formatDateTime(dataset().p_CurrentDate,'MMMM')) > 3
        , formatDateTime(dataset().p_CurrentDate,'MMM')
        , formatDateTime(dataset().p_CurrentDate,'MMM')
    )
    ,'-'
    ,formatDateTime(dataset().p_CurrentDate,'yyyy')
    ,'.csv'
)