TOPIC:

Start date, End Date response 7 months 3 weeks ago #238788

  • Topic Author
  • mrperfectpz
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 244
  • Thanks: 0
Its ok I have working out the problem, I had the wrong ID's. All working perfect now thankyou very much for your help on this you are a genius !!!

Please Log in or Create an account to join the conversation.

Start date, End Date response 7 months 3 weeks ago #238789

  • Topic Author
  • mrperfectpz
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 244
  • Thanks: 0
How would I change the text color for each ?

Please Log in or Create an account to join the conversation.

Start date, End Date response 7 months 3 weeks ago #238798

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 414
Great!

I'm glad that the suggested solution is working for you after all.

To color each status in it's color you can use this code instead of the one previously suggested:
<?php $start = 'col13330'; $end = 'col13331'; if( date("Y-m-d") < $item->$start ){$value="<font color='red'>PENDING</font>";} if( date("Y-m-d") >= $item->$start && date("Y-m-d")<= $item->$end ){$value="<font color='blue'>IN PROGRESS</font>";} if( date("Y-m-d") > $item->$end ){$value="<font color='green'>COMPLETE</font>";}?>

Let me know whether this works for you.

Regards,

Mihaela

Please Log in or Create an account to join the conversation.

Start date, End Date response 7 months 3 weeks ago #238803

  • Topic Author
  • mrperfectpz
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 244
  • Thanks: 0
Perfect thankyou so much !!!

Please Log in or Create an account to join the conversation.

Start date, End Date response 7 months 3 weeks ago #238804

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 414
Hello again,

I'm glad I've helped and that this is working as you wanted. :)

Regards,

Mihaela

Please Log in or Create an account to join the conversation.

Start date, End Date response 6 months 3 weeks ago #239142

  • Topic Author
  • mrperfectpz
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Posts: 244
  • Thanks: 0
Since having sorted this problem I am having to re-visit this and I cannot find the correct col id in my database, can you help me to know where i can find the column id in my database

Please Log in or Create an account to join the conversation.

Moderators: ForumSupport
Time to create page: 0.051 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

Summer Sale!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!