• Registered: 2024-12-21
  • Posts: 83

Topic: Dates in fast report

Hi,
i have many fields with dates in my project , is there any other way then making cf for every date field?
i need date to be like 25.12.2024 and fast report only shows 12.25.2024.
i know fast report see dates from MVD like text.
and if i must make cf for every date field how to add time after date? can you please show me example?
thank you

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,243

Re: Dates in fast report

When I looked at your examples I didn't see anything like that. And what you're describing is strange.
Show an example.

  • Registered: 2024-12-21
  • Posts: 83

Re: Dates in fast report

form invoice datetimepicker , i will attach my project with cf dates

Post's attachments

Attachment icon IGMAhrv30052025.rar 572.45 kb, 21 downloads since 2025-06-02 

  • Registered: 2024-12-21
  • Posts: 83

Re: Dates in fast report

screeshot 1

Post's attachments

Attachment icon 2025-06-02 11_26_28-FormInvoice.png 66.99 kb, 6 downloads since 2025-06-02 

  • Registered: 2024-12-21
  • Posts: 83

Re: Dates in fast report

2

Post's attachments

Attachment icon 2025-06-02 11_30_30-Preview.png 45.91 kb, 6 downloads since 2025-06-02 

  • Registered: 2024-12-21
  • Posts: 83

Re: Dates in fast report

(case strftime('%m',InvoiceDate)              
when '01' then substr(InvoiceDate,9,2)||'.01.'||substr(InvoiceDate,1,4)  
when '02' then substr(InvoiceDate,9,2)||'.02.'||substr(InvoiceDate,1,4)  
when '03' then substr(InvoiceDate,9,2)||'.03.'||substr(InvoiceDate,1,4)  
when '04' then substr(InvoiceDate,9,2)||'.04.'||substr(InvoiceDate,1,4)  
when '05' then substr(InvoiceDate,9,2)||'.05.'||substr(InvoiceDate,1,4)  
when '06' then substr(InvoiceDate,9,2)||'.06.'||substr(InvoiceDate,1,4)  
when '07' then substr(InvoiceDate,9,2)||'.07.'||substr(InvoiceDate,1,4)  
when '08' then substr(InvoiceDate,9,2)||'.08.'||substr(InvoiceDate,1,4)  
when '09' then substr(InvoiceDate,9,2)||'.09.'||substr(InvoiceDate,1,4)  
when '10' then substr(InvoiceDate,9,2)||'.10.'||substr(InvoiceDate,1,4)  
when '11' then substr(InvoiceDate,9,2)||'.11.'||substr(InvoiceDate,1,4)  
when '12' then substr(InvoiceDate,9,2)||'.12.'||substr(InvoiceDate,1,4)  
end)

how to add time after date?

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,243

Re: Dates in fast report

I would just start by learning the SQL Strftime function. Your code would become beautiful and display everything you need.


https://www.sqlite.org/lang_datefunc.html

8 Reply by agusecc (edited by agusecc 2025-06-07 09:56:55)

  • Registered: 2015-12-19
  • Posts: 141

Re: Dates in fast report

Hi IgorMad, maybe you need to try this code:

strftime('%d.%m.%Y %H:%M:%S', InvoiceDate)

Result: : 07.06.2025 14:23:55

OR

strftime('%d.%m.%Y %I:%M %p', InvoiceDate)

Result: 07.06.2025 02:23 PM

  • Registered: 2024-12-21
  • Posts: 83

Re: Dates in fast report

Thank you agusecc, works great