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 |
---|---|
124 | |
87 | |
87 | |
75 | |
69 |
User | Count |
---|---|
215 | |
181 | |
140 | |
97 | |
83 |