web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / POWER AUTOMATE DESKTOP...
Power Automate
Unanswered

POWER AUTOMATE DESKTOP SQL QUERY INSERT DATE MANAGEMENT DATE

(0) ShareShare
ReportReport
Posted on by

I am trying to enter a date in a table, I have date data in a list[0]= 2023-06-20.

When I execute the query, it indicates that I cannot insert an int, it means that it executes the operation.

Try placing the data 2023-jun-20 in the list, it indicates that jun is invalid at the time of insertion.

on the insert try convert(date, %list[0]%,11), it indicates the same errors as above.

How should I store the date in the list or how should I treat the date in the insert?

I have the same question (0)
  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at

    usually specifying single quotes is enough 

     

     list[0]= '2023-06-20'

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard