Hi Experts
I am having issues trying to create a conditional inside a query.
I have a date column ("LastModifiedDate"), which is sometimes null, in the case it is null I want to get the following date “01/01/1900”
Could you please help me ?
query 70639802 "Sales. Inv. Line"
{
QueryType = Normal;
elements
{
dataitem(SalesInvoiceLine; "Sales Invoice Line")
{
column(DocumentNo; "Document No.")
{
}
column(LineNo; "Line No.")
{
}
column(AmountIncludingVAT; "Amount Including VAT")
{
}
column(LastModifiedDate; "LastModifiedDate")
{
}