Hii Guys, can anyone help me how can i filter Date only from date and time in reports

Naresh307
Naresh307 Member Posts: 2
in NAV Three Tier
Thank you

Best Answer

  • DenSter
    DenSter Member Posts: 8,307
    edited 2021-09-02 Answer ✓
    The DT2Date function expects a DateTime value as input. The Depreciation Starting Date field is not a DateTime field, it is a Date field.
    qdsr3qlmubdv.png

    To see the definition of the field you are working with, you can either hover your mouse over it and it will show up in the tooltip, or you can put your cursor in the field and hit F12, which will open the source object
    Daniel Rimmelzwaan
    RIS Plus, LLC

Answers

  • SanderDk
    SanderDk Member Posts: 507
    Please elaborate with what kinda of date (Add some code),or else you won't get any good answer
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • julkifli33
    julkifli33 Member Posts: 1,092
    edited 2021-09-01
    you can try 
    Setfilter("Your Date",'%1..%2',StartDate,EndDate);
  • Naresh307
    Naresh307 Member Posts: 2
    date := DT2DATE("FA Depreciation Book"."Depreciation Starting Date");
    im trying to write above code to extract date from date and time variable i.e Depreciation Start Date
    here date is a local variable of type Date and FA Depreciation Book is the table.
    but im getting fallowing error

    sariby9p81kr.png
  • jordi79
    jordi79 Member Posts: 280
    edited 2021-09-02
    Hi,
    Just use EVALUATE(). And only if this does not work, then you do text manipulation.

    Sample code...

    DTVar is a datetime variable
    DateVar is a date variable
    DTvar := CURRENTDATETIME;
MESSAGE('Before...' + FORMAT(DTvar));

EVALUATE(DateVar, FORMAT(DTvar));

MESSAGE('After...' + FORMAT(DateVar));
  • DenSter
    DenSter Member Posts: 8,307
    edited 2021-09-02 Answer ✓
    The DT2Date function expects a DateTime value as input. The Depreciation Starting Date field is not a DateTime field, it is a Date field.
    qdsr3qlmubdv.png

    To see the definition of the field you are working with, you can either hover your mouse over it and it will show up in the tooltip, or you can put your cursor in the field and hit F12, which will open the source object
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories