topic Date ;; in QlikView

Date ;;

Thu, 15 Oct 2015 07:02:18 GMT

Thanks

Madhu

gautik92 — Thu, 15 Oct 2015 07:08:28 GMT

if(date(vMakeToday)<vToday,Date(vToday,'MM-DD-YYYY'),Date(vMakeToday,'MM-DD-YYYY'))

settu_periasamy — Thu, 15 Oct 2015 07:10:30 GMT

Try,

=Date(if(vMakeToday<vToday,vToday),'MM-DD-YYYY')

simospa — Thu, 15 Oct 2015 07:10:47 GMT

Hi Josna,

first of all, next time write your request in the textarea and not in an attachment: it will help other users with your same problem in the future.

Try to use the Date function to convert che numeric date in a date format: =Date(yourdatefield,'MM-DD-YYYY')

In your example:

= 'Date as of: ' & Date(if(vMakeToday<vToday,vToday),'MM-DD-YYYY')

=if(vMakeToday<vToday,'Date as of: ' & Date(vToday,'MM-DD-YYYY'))

Let us know

gautik92 — Thu, 15 Oct 2015 07:12:19 GMT

=Date(if(vMakeToday<vToday,vToday),'MM-DD-YYYY')

avinashelite — Thu, 15 Oct 2015 07:13:54 GMT

try like this :

if(vMakeToday<vToday,vToday,Date(vMakeToday,'MM-DD-YYYY'))

Thu, 15 Oct 2015 07:45:58 GMT

Hi Simone

Ok Fine thank you very much for giving suggestion.

Josna.

avinashelite — Thu, 15 Oct 2015 07:54:09 GMT

if you have got the answer, please mark the correct answer and close this thread