Group by Date

CraigCraig
edited 2:57AM in FastReport 2.xx VCL
I am making a columnar report that I want to group by date (September 1, 2004). My data is in a DateTime field (09/01/2004 11:30am). How do I extract the date for grouping condition?

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 2:57AM
    try using the formatdatetime function

    [FORMATDATETIME('mm/dd/yyyy', [tblname."fldname"])]

    ;)
  • CraigCraig
    edited 2:57AM
    Worked perfectly
    Thanks

Leave a Comment


Home • FastReport 2.xx VCLComment As ...

© Vanilla Keystone Theme 2025