Home Page
Articoli
Tips & Tricks
News
Forum
Archivio Forum
Blogs
Sondaggi
Rss
Video
Utenti
Chi Siamo
Contattaci
Username:
Password:
Login
Registrati ora!
Recupera Password
Home Page
Stanze Forum
Crystal Reports e reportistica
Date formula
venerdì 16 marzo 2007 - 17.01
Elenco Threads
Stanze Forum
Aggiungi ai Preferiti
Cerca nel forum
aleplgr
Profilo
| Junior Member
51
messaggi | Data Invio:
ven 16 mar 2007 - 17:01
Hi! in the Orders table of the xtreme database I'm trying to show all records greater than 05/03/2004, I want to show just the order Id and the Order Date.
To do that I defined the formula {Orders.Order Date}>= #05/03/2004#
and I formatted the field by rightclicking it and selecting in the Date tab the format I want: DD/MM/YYYY it shows the example format 01/03/1999 also shows Day 01, Month 03, Year 1999. And when I run the report without any formula it shows all the date fields correctlly in this format and in the right order.
But when I run the report with the formula it shows all the records starting from 03/05/2004
it should show the order Id 1403 first, this Order has Order Date 05/03/2004, what's happening?
I think it's about the #, I think it does not get the date as a date in the formula...
freeteo
Profilo
| Guru
6.542
messaggi | Data Invio:
gio 22 mar 2007 - 19:46
Hi, and sorry 4 late...
The problem is that the formula Field of the report, doesn't works like a normal sql syntax, so the "#" char, is not the right way to set a value for the date field.
Try in this way :
{myfield} > Cdate('05/03/2004')
ciao.
Matteo Raumer
[MCAD .net]
http://blogs.dotnethell.it/freeteo
Torna su
Stanze Forum
Elenco Threads
Partecipa anche tu! Registrati!
Hai bisogno di aiuto ?
Perchè non ti registri subito?
Dopo esserti registrato potrai chiedere
aiuto sul nostro
Forum
oppure aiutare gli altri
Consulta le
Stanze
disponibili.
Registrati ora !