FrankKoster (Customer) to rsaSFDCadmin (RSA): asked a question.
Date format in collectors (last login date)
We get this error in our (multiapp) collector.
Data Format Error in Account Record. Record ID=AAAAAA,
Attribute=LAST_LOGIN_DATE, Value="2022/04/04", Expected Data Type=DATE
Problem: Invalid Date Format or Date Range Acceptable Date Range From:
01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59
We convert all dates to YYYY/MM/DD.
What should be the correct Date format in IG&L 7.5 for Last Login Date?
Data Format Error in Account Record. Record ID=AAAAAA,
Attribute=LAST_LOGIN_DATE, Value="2022/04/04", Expected Data Type=DATE
Problem: Invalid Date Format or Date Range Acceptable Date Range From:
01-Jan-0001 00:00:00 To: 31-Dec-9999 23:59:59
We convert all dates to YYYY/MM/DD.
What should be the correct Date format in IG&L 7.5 for Last Login Date?
fine collecting it as is. However, if it's kept as a string data type in the
database, you should format it to MM/DD/YYY format during collection time.