cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samudiho07
Frequent Visitor

get date of Microsoft Forms

I want to get the date generated by Forms from the excel, to send it by mail but I get a date without format.

 

the one on the left is how it gives Forms, but the one on the right is when I want to extract it from Excel.

Samudiho07_0-1608062202120.png

as I do to extract it from Excel but with the date format?

1 ACCEPTED SOLUTION

Accepted Solutions
sakula1996
Responsive Resident
Responsive Resident

Hi @Samudiho07 

 

You have to use expression to convert Excel date to normal date.

Replace -- outputs (body (' List_the_lines_in_a_table ')? [' Value '] [' Request Date (DT) '] ) With your variable.

 

 (adddays ('12 -30-1899 ', int (outputs (body (' List_the_lines_in_a_table ')? [' Value '] [' Request Date (DT) '] )), 'yyyy-MM-dd),' yyyy-MM-dd ')

View solution in original post

1 REPLY 1
sakula1996
Responsive Resident
Responsive Resident

Hi @Samudiho07 

 

You have to use expression to convert Excel date to normal date.

Replace -- outputs (body (' List_the_lines_in_a_table ')? [' Value '] [' Request Date (DT) '] ) With your variable.

 

 (adddays ('12 -30-1899 ', int (outputs (body (' List_the_lines_in_a_table ')? [' Value '] [' Request Date (DT) '] )), 'yyyy-MM-dd),' yyyy-MM-dd ')

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (47,541)