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...
Solved! Go to Solution.
Use:
Set(varCalKitPM_CalDate, DateValue(First(colCurrentRecord).PM_Cal_Date),"en-US");
change "en-US" based on your needed date format.
Hope it helps !
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!!
User | Count |
---|---|
254 | |
101 | |
94 | |
47 | |
37 |