Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Brand new to QlickView and found the Out Of The Box demo to be very helpful getting started. The demo uses the MONTH function to obtain month from a date field but I can't get it to work with a string. During the load process:
Can someone explain why I don't get these values in my list box?
Cheers,
-Keith
Take care of the format codes for Month 'MM' vs minutes 'mm'.
month(Timestamp#(payment_date, 'MM/DD/YYYY hh:mm:ss')) as month,
Take care of the format codes for Month 'MM' vs minutes 'mm'.
month(Timestamp#(payment_date, 'MM/DD/YYYY hh:mm:ss')) as month,
Hello,
can you please try the following : =month(date(floor(date_col)))
Thanks
As swuehl says mm refers to minutes, MM to month!
I always use uppercase for date formats, lowercase for time formats to avoid this confusion.
date(date#(payment_date, 'MM/DD/YYYY hh:mm:ss')) as payment_date,
year(date#(payment_date, 'MM/DD/YYYY hh:mm:ss')) as year,
month(date#(payment_date, 'MM/DD/YYYY hh:mm:ss')) as month
Is there a big difference between date# and timestamp#?