Setting a 'Date' variable from a collection

[LeeB_CDN]

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... 

[gabibalaban · Accepted solution]

@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 !

[LeeB_CDN]

Hi, @gabibalaban 

That was close, just needed this: 

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

Thanks so much!!