Unanswered

Converting Date from Run Query against Dataset from ISO 8601 to 'DD/MM/YYYY'

(0) Share

Report

Posted on by ADDLarter

I have a flow that runs a query against a database and puts it into a CSV table

The date in the query returns in the ISO 8601 format (e.g. 2023-10-11T00:00:00), but I need it to have dd/mm/yyyy

the select portion is just to rename column headers as i need the space between words, and no square brackets.
I used this expression item()?[Column Header]. Tried to wrap a format time around this but it didnt work

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @ADDLarter ,

Please try this

formatDateTime(item()?['Column Header'],'dd/MM/yyyy')

Best Regards,

Wearsky

Was this reply helpful? Yes No
ADDLarter 8 on at

Like (0)

Report

Unfortunately it doesn't work, I get this:

'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @ADDLarter ,

Try this:

if(equals(item()?['Column Header'],null),'',formatDateTime(item()?['Column Header'],'dd/MM/yyyy'))

Best Regards,

Wearsky

Was this reply helpful? Yes No
ADDLarter 8 on at

Like (0)

Report
This returned Blank
a bit more context
My output looks like this:
my dax query i run is:
DEFINE VAR __DS0FilterTable = FILTER ( ALL('Combined CACSTOREADVICE'), 'Combined CACSTOREADVICE'[Start Date] >= TODAY() && 'Combined CACSTOREADVICE'[Start Date] < TODAY() + 7 ) VAR __ColumnsToSelect = SELECTCOLUMNS ( SUMMARIZE( __DS0FilterTable, 'Combined CACSTOREADVICE'[Start Date] ), "Start Date", 'Combined CACSTOREADVICE'[Start Date] ) VAR __FilteredColumns = FILTER ( __ColumnsToSelect, NOT ( ISBLANK ([Start Date] ) ) ) EVALUATE __FilteredColumns

After this I have to rename the columns:
using the item()?['Combined CACSTOREADVICE[Start Date]']

Was this reply helpful? Yes No