cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LeeB_CDN
Helper III
Helper III

Setting a 'Date' variable from a collection

Hello, World

 

Does anyone have the solution for populating a global variable (type: Date) from a collection? Here is the function that throws the "Incompatible Type" error:

Set(varCalKitPM_CalDate, First(colCurrentRecord).PM_Cal_Date);

The PM_Cal_Date column in the collection contains the following date and format: "5/07/2020"

 

Thanks in advance, as always... 

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Dual Super User
Dual Super User

@LeeB_CDN ,

Use:

Set(varCalKitPM_CalDate, DateValue(First(colCurrentRecord).PM_Cal_Date),"en-US");

change "en-US" based on your needed date format.

Hope it helps !

View solution in original post

2 REPLIES 2
gabibalaban
Dual Super User
Dual Super User

@LeeB_CDN ,

Use:

Set(varCalKitPM_CalDate, DateValue(First(colCurrentRecord).PM_Cal_Date),"en-US");

change "en-US" based on your needed date format.

Hope it helps !

Hi, @gabibalaban 

 

That was close, just needed this: 

Set(varCalKitPM_CalDate, DateValue(First(colCurrentRecord).PM_Cal_Date);

 

Thanks so much!! 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,127)