Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to figure out why one dates ( 2017 - 07 - 10 ) does not convert in my data to the required format.I have tried , floor,date#,date, all the function i know .. not able to find a reason why that date remains with the timestamp in it..
Can someone help me to resolve this puzzle
Thanks!
Dear Steve, maybe you have some trouble with a date cast, for these values use another format
This Expresión will be usesfull:
Alt(
Date("DateText"),
Date(Date#("DateText",'YYYY-DD-MM')),
Date(Date#("DateText",'DDMMYYYY hh:ss tt'),
.....(Here you can put another format to cast))
)
Which date is it? I see all of them read as date... can you take a screenshot to show it?
CaseClosedDate , please find the attached document.
just 2017-07-10 does not change.
hi Steve! maybe it will be a text with a diferent format, try to use the alt() Function, where you can do format for diferents types of dates, for example
Alt(date(text),date#(text,'YYYY-DD-MM').....)
Did you try with this?
date(floor(date#(CaseCloseDate,'MM/DD/YYYY')))
I think that maybe you have to convert the field in a number and later apply the floor function.
Let me know if it works
Please select Number tab in the list box & click on override document setting & select Date format.
Thanks.
if i use Alt and when i put Caseclosedate in list box i see value for each date instead in 1 values of a date with different timestamps .. how do i avoid that .. can you please provide full expression.
Dear Steve, maybe you have some trouble with a date cast, for these values use another format
This Expresión will be usesfull:
Alt(
Date("DateText"),
Date(Date#("DateText",'YYYY-DD-MM')),
Date(Date#("DateText",'DDMMYYYY hh:ss tt'),
.....(Here you can put another format to cast))
)