I have a column in my Excel sheet that I am creating using LibXL that is a Date column
When I pass the date, I pass it as a Number, but for it to display accurately I have to subtract 14 days:
Code:
Set peNumFormat of hoStayRowDateFormat to XL_NUMFORMAT_CUSTOM_D_MON_YY
...
Move STAYS.DATE_IN to iDateVal
Send WriteNumberWithFormat of hoSheet iRow 2 (iDateVal-14) hoStayRowDateFormat
If I don't subtract 14 days, the date is consistently 2 weeks later than the date value stored in the Dataflex field.