I'm going to get back with you by the end of the week on this one. I haven't yet used a timestamp in a BI Pub Report. My thought is that you have to first define your field in PeopleSoft as a date/time and make sure the time is correctly populated by the application. Then, use the same method in the RTF or Excel template, just allowing for the time instead of just date. This may be a good idea for a quick short how to on the channel Thanks!
Sateesh did you ever solve this problem? The alternative solution we're thinking of going with is changing the psquery select from DD/MM/YYYY HH:MM to YYYY/MM/DD HH:MM and not having another template column that transforms into an actual date format, this way we can have the time part and sorting will have the appearance of working.
Not that I’m aware of. You can start just by bringing in as text and displaying the next if it doesn’t matter if that field is type text and not date. The human will see it as a date
Thank you!! Exactly what I needed. Wish we didn't have to have to have hidden columns to make something so basic work!
How to convert Timestamp value (TEXT format) to Date format. Datevalue formula is truncating the time to 00:00:00.
I'm going to get back with you by the end of the week on this one. I haven't yet used a timestamp in a BI Pub Report. My thought is that you have to first define your field in PeopleSoft as a date/time and make sure the time is correctly populated by the application. Then, use the same method in the RTF or Excel template, just allowing for the time instead of just date.
This may be a good idea for a quick short how to on the channel
Thanks!
Sateesh did you ever solve this problem? The alternative solution we're thinking of going with is changing the psquery select from DD/MM/YYYY HH:MM to YYYY/MM/DD HH:MM and not having another template column that transforms into an actual date format, this way we can have the time part and sorting will have the appearance of working.
I’ve tried as it is but it’s not working.
Just guessing
But make sure the column bringing in the date from the XML file is formatted as text.
Then use the excel date formula on that text field
Yeah, I’m going through the same steps but still it’s not working. And is there any way can we do this with out creating a column.
Not that I’m aware of.
You can start just by bringing in as text and displaying the next if it doesn’t matter if that field is type text and not date. The human will see it as a date