When displaying the contents of a folder using the structure report in the web client – the effective date is displaying the wrong month, and the wrong day of the week, - see example in the attached file
Hi Sue, I will check into it for you...
Hi,
Are you using any eQL for retrieving this report?
If yes, then please share the eQL which is generating this report.
From the 'dateeffective.doc' file, it seems that, effective date is taking a month back date.
Regards
Swapnil Tapadia
Hi Sue,
Could you create a report using script below please. And let us know how it works on your system.
START WITH Document
SELECT
Id,
DateEffective,
AuditDetails.AuditDate,
CAST( AuditDetails.AuditDate AS STRING, 'dddd, MMMM' ) + ' ' + CAST( AuditDetails.AuditDate AS STRING, 'dd , yyyy' )
WHERE
1 = 1
Thanks,
NT
the results are in the attached file - looks like it worked though
I am using the buitl-in folder structure report.