Remove time from column

(0) Share

Report

Posted on by Amirin

128

Hi Guys,,

I have a file that needed to be copied into other file.

But the raw file have a column that have both date and time.

I only want to get the date and omit the time.

And this is my flow

Categories:

General topics

I have the same question (0)

All responses (19)

Answers (1)

SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Use formatDateTime([Your date field data], 'd') as dynamic content expression. 'd' is the short date pattern format.

Regards.

Was this reply helpful? Yes No
Amirin 128 on at

Like (0)

Report
Copy link

Link copied!

Hi.. I am new
Can you please show where I will put it?

Was this reply helpful? Yes No
Verified answer

SamLed 2,340 Moderator on at

Like (1)

Report
Copy link

Link copied!

Here a small test flow I made for you :

Where the map value is : formatDateTime(item()?['Paid Date'], 'd')

Use the same expression for every date you want to format. Also pay attention to the DateTime format in the "List rows present in a table" action. it must be "Iso 8601" when you get data from Excel.

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Amirin 128 on at

Like (0)

Report
Copy link

Link copied!

Hi..
Sadly I got this Error

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

It works on my side...

formatDateTime(item()?['Paid Date'], 'd') and formatDateTime(item()?['Add Date'], 'd')

Can you copy/paste me the whole error message, it is truncated in your screenshot.

Was this reply helpful? Yes No
Amirin 128 on at

Like (0)

Report
Copy link

Link copied!

Here you go

The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{
"Paid Date": "@formatDateTime(item()?['Paid Date'], 'd')",
"Add date": "@formatDateTime(item()?['Add date'], 'd')"
}' failed: 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you selected the correct DateTime format (ie ISO 8601) in the "List rows present in a table" action ?

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Well it seeams you have null value in one or more rows in one or more date columns...

Was this reply helpful? Yes No
SamLed 2,340 Moderator on at

Like (0)

Report
Copy link

Link copied!

Replace formatDateTime(item()?['Paid Date'], 'd') by if(empty(item()?['Paid Date']), '', formatDateTime(item()?['Paid Date'], 'd'))

Was this reply helpful? Yes No
Amirin 128 on at

Like (0)

Report
Copy link

Link copied!

I am looking at my sample data.. And I don't have any null value.

Thank you for answering me,, I am now logging off and hopefully tomorrow will find a solution.

Was this reply helpful? Yes No