Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a little problem with my date creation for an app.
I have .csv file, with a field that represent a timestamp, for example "01-09-2016 07:49:00".
I try to create a date field on my script like this :
date(ceil("Time"), 'DD-MM-YY') as "Date"
But when I use my field date on a dashboard I get something like "16-09-2001". The date is reversed and I don't know what I do wrong.
Can someone help me please?
Thank you in advance.
Try this:
Date(Floor(Date#(Time, 'DD-MM-YYYY hh:mm:ss'))) as Date
It worked.
Thnak you.