arslan
June 15, 2016, 6:32pm
1
Hi All. i am facing date issue in Report.
This is Report Code
[Today:1,1,1,1,1]
>Date|Ticket No|Person|Delivery Date|Amount
{REPORT TICKET DETAILS:T.Date,T.TicketNumber,TT.Order Type,TT.Delivery,T.TotalAmount}
Please Guide me where’s my mistake
Thanks.
I would hazard a guess that that is a timestamp for the date…
If you call that tag in a show message or ask question what do you get?
arslan
June 15, 2016, 6:38pm
3
But in Ticket Template ticket tag Date working fine but not in reports.
arslan
June 15, 2016, 6:45pm
4
This is what i get from Ask question.
Hmmmm… was a hazard of a guess, if that E+17 makes the number 636017184000000000 its not a timestamp anyway…
Jesse
June 15, 2016, 6:48pm
6
Show your rule you used to create the ticket tag.
arslan
June 15, 2016, 6:50pm
7
Code is Here
[?Enter Delivery Date;([1-9]|10|11|12) (0?[1-9]|[12]\d|30|31) \d{2}\d{2}?;{TICKET TAG:Delivery};Cancle,OK]
Jesse
June 15, 2016, 6:53pm
8
So how does it look in the database?
arslan
June 15, 2016, 6:53pm
9
[{“TN”:“Delivery”,“TT”:3,“TV”:“6/17/2016”},{“TN”:“Factory”,“TT”:0,“TV”:“Waiting”}]
Jesse
June 15, 2016, 6:54pm
10
Those slashes are confusing it. You would have to escape those or store date in an actual date format.
arslan
June 15, 2016, 6:55pm
11
how ? will you please help to solve this issue
Or use something else instead of /
1 Like
Jesse
June 15, 2016, 6:57pm
13
The forward slash is reserved so use something else instead. Or use script to generate a date that’s valid.
arslan
June 15, 2016, 7:02pm
14
how i use ? i don;t know dear ?
Id just use -
instead if it was me, simpler option.
Really?
It wont backdate tags you know right…
arslan
June 15, 2016, 7:12pm
18
1 Question.
why this ticket tag date working fine in Ticket Template and also on Ask Question.
but not working on Reports ?
i think something wrong in report code
what do you think @JTRTech ?
Jesse
June 15, 2016, 7:12pm
19
There is nothing you can do to fix old tickets. Try it for new ticket .
Jesse
June 15, 2016, 7:12pm
20
I explained why, it’s not the syntax. Reports use those symbols for things like calculations etc so they are reserved.
You should be storing an actual date format anyway.
1 Like