Good Morning,
I am using one view
for that i have Added Query and to that Query i added datasource PurchAgreementHeader and Fields - Yes
Now when i drag that Query to new View
I am Unable to get CreatedDateTime .
So i have Written Computed Column to Return CreatedDatetime
and Added one DateComputedColumn Field for View and i am able to see data now for that Date Computed Column.
But now the problem is i need it to return as date.as of now it is returning UTC Date time format.
How can i get Date For Created Date Time in View Method.
my method is a s follows.
public server static str AgreementStartDate()
{
SysDictTable purchagreementheader = new SysDictTable(tableNum(PurchAgreementHeader));
DictView dv = new DictView(tableNum(PurchaseCommissionReportView));
str createddatetime;
createddatetime = strFmt('SELECT TOP 1 (%1) FROM %2 WHERE %2.%3 = %4',
purchagreementheader.fieldName(fieldNum(PurchAgreementHeader,CreatedDateTime),DbBackend::Sql),
purchagreementheader.name(DbBackend::Sql),
purchagreementheader.fieldName(fieldNum(PurchAgreementHeader,PurchNumberSequence),DbBackend::Sql),
dv.computedColumnString(tableStr(PurchAgreementHeader),fieldStr(PurchAgreementHeader,PurchNumberSequence),FieldNameGenerationMode::WhereClause));
return createddatetime;
}
I have PurchNumberSequence(Agreementid).and then i am Returning its CreatedDAteTime.
It is coming .But i need in Date.
Please show some light.
Regards.
Have a great day.
