VB code for best way for check Date is less then or Grater then Question :   What is the best way for date > or < Dim mMyDate as date Then we store date from perticuler tabel using Record Set like mMyDate=MyRst!Date_Of_Joining If mMyDate > now then Msgbox " Date_Of_Joining > Today" it is ok or we need to use format functione like If format(mMyDatem,"DD/MM/YYYY") > format(now,"DD/MM/YYYY") then Msgbox " Date_Of_Joining > Today" End if and one thing if we will use format(mMyDatem,"MM/DD/YYYY") > format(now,"MM/DD/YYYY") then result will be same or not? Answer (2)    The only correct way to test for formatted dates being greater or less than another is to format them in yyyyMMdd format.  _ For example, using the below with myDatem being 05/07/2009 and today being 04/07/2010, you would get 05/07/2009 being later than today which is clearly not the case. You must ensure the date values are left padded with zeroes for the months of January thru September and the day of the month < 10 and the way do to this is the use the yyyyMMdd format characters. _ If you were to format them as 2009/07/05 compared to 2010/07/04, the comparison would work correctly. _ Hope this helps. Answer (2)   If you have dates in the form of Date values (for example, if you retrieve  the value from a Date/Time field to a Date variable, or if you get the value  of the Now() function), you should compare them AS DATES:  * Comparison as dates if much faster than comparison as strings  * Conversion to formatted strings adds even more unnecessary  processing time  * String conversions can lead to incorrect results  In particular, the following statement:  ..  If Format(myDate, "dd/mm/yyyy") > Format (Now(), "dd/mm/yyyy")  ..  will give the wrong result approximately HALF THE TIME, because string  comparisons will compare the day number BEFORE comparing the month number or year number. Therefore, 29/01/1999 will be greater than 01/12/2010, because  29 is greater 01.  There is absolutely NO reason to convert dates to strings to perform  comparisons for greater than or less than.  However, you do need to be careful when comparing dates for equality. A Date  may be for any time of day. The statement:  ..  myDate = CDate("04/07/2010")  ..  will create a date/time value that is equal to:  ..  2010/07/04 00:00:00  ..  but the function Now() will return a value that may have any time value at  all. If you plan to do a comparison for equality, make sure that you  TRUNCATE your date/time value to only the date. While one way to do that is  to convert the date to a formatted string and then convert the string back  to a date, it's extremely inefficient. A much more efficient way to do it is  to use the various date/time functions:  ..  Dim today As Date  today = Now()  today = DateSerial(Year(today ), Month(today ), Day(today))  ..  In some environments, the Date() function MAY return a date/time value that  contains only the date (and an effective time of midnight). You should  verify that before using the Date() function without applying truncation to  the results.  Michael S. Meyers-Jouan

STUDIES SHOW FAKE HONEY IS EVERYWHERE – HERE ARE 10 TRICKS TO TELL IF YOUR HONEY IS TRULY NATURAL

STUDIES SHOW FAKE HONEY IS EVERYWHERE – HERE ARE 10 TRICKS TO TELL IF YOUR HONEY IS TRULY NATURAL

1. Read the contents

This is the first step that will help you find the right ingredients in order to choose good honey which contains no additives. The producer must appoint the contents and their percentage by a certain amount.

2. Natural honey is not sticky

A good test would be if you take a little honey and rub it between your fingers. Real honey is easily absorbed into the skin. If it remains sticky, It means that It contains sugar or artificial sweeteners.

3. Caramelizing

Put a few teaspoons of honey into a bowl and heat it to a high temperature in a microwave. Real honey gets caramelized, while the false becomes foamy and full of bubbles.

4. Paper

Put a few drops of honey on paper. If the honey does not break the paper after some time, it is a natural one. Otherwise, one that contains water in its composition will break the paper just a few seconds.

5. The trick with bees

Ants pass by real honey, produced by bees. Try this and put some honey in a corner. If ants do not touch it, it means that your honey is natural.

6. Water with honey

This is the easiest indicator of the correct composition of honey. Pure honey, when put in water, makes lumps and falls to the bottom of the cup, while the false one melts.

7. Tingling in the month

Pure natural honey causes tingling and mild inflammation of the tongue, while the false has no effect on the palate.

8. Honey on Bread

Put some honey on a piece of bread. If bread becomes hard, honey is completely natural. If it only dampens the surface of the piece of bread, it is false, because of the large amount of water in its composition.

9. Egg yolks

Mix one egg yolk with a little honey. If honey is natural, the yolk will look like cooked.

10. Crystallization

Pure honey crystallizes with time, while the other honey, even after a long period, keeps its liquid composition in the form of syrup.

Source: http://www.naturalcuresandhomeremedies.com/

Make it Yourself – Anti aging syrup with Garlic, Lemon and Honey

Preparation: Finely grind 10 heads of garlic, and mix them with 1 kg of honey and juice of 10 lemons. Put the mixture in a glass bowl, cover and leave to rest for 8-10 days. After 8-10 days, take one tablespoon of the mixture twice a day, before meals.

This mixture of garlic, lemon and honey slows down the process of aging.

87 Ways to Instantly Transform Thoughts from Negative to Positive

Written by P. James Holland

Positive thinking sucks!

Positive thinkers suck!

They just seem to always be smiling.

They jump out of bed at 6:00 a.m. singing and you feel like giving them a swift karate chop in the “Vulcan grip” area.

They’re not bad people, but when you ask them the secret to their happiness, you usually get that lame and unactionable answer:

“I’m an optimist. I always keep positive thoughts in my head”

Gag!

That does nothing for you.

When you are stuck in traffic and already 15 minutes late, you are not thinking positively.

When you get home and the house looks like Chuck E. Cheese threw up on it, you most certainly are not looking for the benefits.

There has to be more to it.

Thinking Positively Is Too Hard – What To Do Instead

A hidden trick exists to changing a negative mind immediately.  The following list will reveal it.

Some will improve your health.

Others will increase your wealth.

Some will make you laugh. Some will make you think.

Some will be simple and some will be deep.

Some will make you forget what you were thinking about.

The goal is to get your mind on a whole new route.

Anthony Robbins calls it pattern interrupt.

Negative thinking is a habit. You are not born being a negative thinker.  You had to learn it over the years. Now it becomes a natural response.

I want to break that natural response.  The goal is to shake things up. Stir the pot. Get out of the comfort zone, and any other cliché phrases you can think of.

This post is not the typical post you would normally see on CYT.  I did this purposely.

We can choose to deliberately interrupt our negative thinking patterns by frequently shocking ourselves!

You will have 87 special ways you can immediately interrupt your negative thinking habit before it takes hold on you.

Print it.  Highlight your favorites.  And when you feel like punching someone, instead pull out your trusty list and put one or more into action immediately.

WARNING: May Cause Hysterical Laughter

If you are at work, you may want to read this later. CYT cannot be held accountable for conditions including but not limited to:

• Laughing out loud
• Disturbing Co-workers
• Milk squirting from nose
• Wetting of pants
• Falling out of chair
• Busting a gut

Or

• Splitting of sides

YOU HAVE BEEN WARNED. PROCEED WITH CAUTION.

87 Pattern Interrupts For Positive Thinking Habits

1. Kiss somebody and try to exchange your gum.
2. Laugh out loud in a public restroom so it echoes.
3. Eat some candy while waiting in line.
4. Pet an animal you are afraid of.
5. Say thank you for anything.
6. Compliment someone you know needs to hear it.
7. Slide down a banister.
8. Plant something.
9. Sprint as fast as you can like Phoebe Buffay (YouTube it).
10. Take a silly picture.
11. Prank someone with a short temper.
12. Play your favorite song – LOUDLY!
13. Read a book and tell someone else what you read placing yourself in the story.
14. Spin until you are dizzy.
15. Blow bubbles – Gum. Soapy wand. Bathtub (your choice).
16. Walk in nature.
17. Watch a funny movie.
18. Call a friend while running a lawn mower.
19. Plan a vacation.
20. Hug someone — preferably a stranger.
21. Attempt a cartwheel.
22. Adopt a pet.
23. Dance naked to Richard Simmons’ “Sweatin to the Oldies.”
24. Sleep naked on silk sheets.
25. Swim naked.
26. Ride a bike naked.
27. Basically – do anything you would normally do, but naked.
28. Bake something and pass it out to your neighbors.
29. Go to the zoo and insist that you must be caged before “IT” happens again on a full moon.
30. Go to the museum and convince people you have time traveled.
31. Get a tattoo in an awkward place.
32. Inhale from a helium balloon and order a pizza.
33. Watch Sesame Street and play along.
34. Take a nap on a park bench.
35. Get a massage.
36. Jump in a pool fully clothed.
37. Do push-ups while trying to play the harmonica.
38. Arm wrestle your neighbor.
39. Whistle show tunes during your next meeting.
40. Meditate.
41. Sing kareo… karioak…carryok…sing in public at a bar.
42. Buy me something.
43. Buy yourself something.
44. Get a giant frozen yogurt bowl and eat without a spoon.
45. Try on expensive clothes and call everyone “Dahling” in your best I’m-better-than-you-because-I-am-so-glamorous voice.
46. Test drive a new car and make them buy you lunch. They do it EVERY time!
47. Let it out – Go in your closet and SCREAAAAM!
48. Pinch yourself to see if you’re dreaming. If not, give yourself permission to do so freely.
49. Read anything by Louise L. Hay.
50. Bowl with your opposite hand and hold a slice of pizza in the other.
51. Get a manicure – guys and gals!
52. Walk barefoot in the grass.
53. Brush your hair – proven to be relaxing.
54. Play Words With Friends…. WITHOUT CHEATING! You know who you are.
55. Have a Jam Session – play an instrument with high school buddies.
56. Skip rocks at the lake. If you’re not near a lake, skip dinner plates at the park.
57. Reread the popular posts on the right.
58. Dump negative friends.
59. Get acupuncture. Have no idea if it works, but I guarantee when they bring out the needles, you will have forgotten all about your troubles.
60. Watch someone else get acupuncture – better.
61. Paint something. No brushes. Just hands. Spray paint counts. Just be a fast runner if you have a passion for graffiti.
62. Listen to ambient sounds – those soft relaxing tones that lower your brain wave frequency.
63. Go to the pet store and hold something slimy.
64. Have faith that all is well.
65. Take a long hot bath.
66. Turn off your cell phone – miracle drug right there.
67. Ignore others opinions and start valuing your own.
68. Overcome a fear – do something you are afraid to do.
69. Hang out at the library and scream “NORM!” as each person walks in (showing my age again).
70. Break something — cheap.
71. Go through a drive-thru and order for here.
72. Challenge your negative thoughts for validity.
73. Get a black light and scan your bedroom like you are on CSI.
74. Look for something to be grateful for right this minute.
75. Spend time alone – but do it with friends, family and strangers.
76. Get a facial with all the fixin’s – mud mask, fancy cucumbers on your eyes, a margarita, the works.
77. SMILE =-) – Neurological changes happen in the brain just by smiling.
78. Put the past in the past – Hakuna Matata.
79. Learn EFT – The in-home acupuncture kit… without the needles.
80. Climb a tree.
81. Go to your happy place.
82. Help a stranger.
83. Write in your journal about your life as seen by your 3rd grade teacher.
84. Have a glass of Chianti — at 9:00 a.m.
85. Know there is no such thing as failure – only giving up.
86. Subscribe to the CYT newsletter.
87. Email me and I will personally send you more!

What To Do Next

Emotions can easily get the best of you.

But letting go, getting silly and purposefully feeling good is a lot more fun.

This little list has no power if you do not use it.

You can create your own list and I would highly recommend it.

You do not have to be a victim to your negative thinking habits. Now that you know how they work, destroy them.

They do not serve you or anyone else.

I could sum it all in 6 words:

Change Your Thoughts, Change Your Life.

Please leave a Comment to Show your appreciation of the author

About the author

P. James Holland

Coach Comeback (@CoachComeback) has been through your worst nightmare and lost EVERYTHING! Hear how he and 14 others applied CPR For Your Life and made a complete life reinvention in less than 30 days and how you can too here: The 30 Day Comeback

Job Opening for Male Nurse - Oman at Sofomation in Muscat , Zufar - Oman

Job Opening for Male Nurse - Oman

at Sofomation in Muscat , Zufar - Oman

Education:Basic - Bachelor of Science(Nursing)

Nationality:Egyptian, IndianAlgerian, Indian

Industry Type:Hotels / Hospitality

Functional Area:Doctor / Nurse / Paramedics / Hospital Technicians / Medical Research

Job Description

We are - SOFOMATION - a human resource staffing agency providing highest standards of quality and professionalism. We pride ourselves on our efficient, professional and yet personal services both to our clients and applicants and our ability to supply the right staff complements the recruitment needs of our esteemed client.

We are having the following urgent openings in Oman for one of the leading “EPC Company” for the Position of “Male Nurse”

Job Title: - Male Nurse
Copany Name: Rukun Al Yaqeen (RAY) Skills Development 
Job Location:- Muscat Ghala or Halban
Interview Date & Location : Manila – 03th or 04th of April 2015

Job Qualification

• Bachelor of Science (Nursing)
• Should be Arabic speaker
• Pleasing and pleasant
• Good interpersonal skills

Role & Responsibility
• 3 to 5 years experience
• Coordinating services for patients as needed, round the clock
• Attending to the calls at all times
• In charge of the nursing facility available in the premises

Please share your updated resume with following details for onward submission to client for shortlisting.

• Total years of work Experience :-
• Highest Qualification:-
• Current Salary (USD):-
• Expected Salary (USD):-
• Date of Birth:-
• Nationality:-
• Contact Number & Email Id:-
• Current Location:-

Click here to Apply this job

http://www.naukrigulf.com/job-listings-Job-Opening-for-Male-Nurse-Oman-Muscat-Zufar-Oman-Sofomation-3-to-8-years-180315000038-?xz=&jobId=180315000038&key=&keyar=&loc=oman&exp=&srchRank=10&srchId=142717881192836000&currPage=1&sort=relevance&freshness=&compType=&companyId=&partnercompany=&userSource=

Job Opening for Filipino Lab Technician Trainer

Job Opening for Lab Technician Trainer - Oman - 

at Sofomation in Muscat - Oman , Zufar - Oman

Nationality : 

Filipino

Job Description

We are - SOFOMATION - a human resource staffing agency providing highest standards of quality and professionalism. We pride ourselves on our efficient, professional and yet personal services both to our clients and applicants and our ability to supply the right staff complements the recruitment needs of our esteemed client.

We are having the following urgent openings in Oman for one of the leading “EPC Company” for the Position of “Lab Technician”

Job Title: - Lab Technician
Copany Name: Rukun Al Yaqeen (RAY) Skills Development 
Job Location:- Muscat Ghala or Halban
Interview Date & Location : Manila – 03th or 04th of April 2015

Job Qualification

• Bachelor Degree in chemistry 
• Minimum 5 years of experience
• Should have analytical and research abilities
• Well-spoken and pleasing in personality

Role & Responsibility
• Minimum 5 years of experience
• Petrochemical laboratory skills. 
• Analytical testing 
• Strong and analytical chemistry skills
• Knowledge on the use of LIMS

Please share your updated resume with following details for onward submission to client for shortlisting.

• Total years of work Experience :-
• Years of Experience in Oil & Gas Industry:-
• Highest Qualification:-
• Current Salary (USD):-
• Expected Salary (USD):-
• Date of Birth:-
• Nationality:-
• Contact Number & Email Id:-
• Current Location:-

Clich here for Apply

http://www.naukrigulf.com/job-listings-Job-Opening-for-Lab-Technician-Trainer-Oman-Muscat-Oman-Zufar-Oman-Sofomation-5-to-10-years-230315000075-?xz=&jobId=230315000075&key=&keyar=&loc=oman&exp=&srchRank=3&srchId=142717881192836000&currPage=1&sort=relevance&freshness=&compType=&companyId=&partnercompany=&userSource=

IT - Support Executive

at Dhofar Cattle Field in Raysut - Salalah - Oman

Job Description

Manage Feed Mill day to day Operations with IT related Support. 

• Installing and configuring computer hardware, software, systems, networks, printers and scanners
• Maintaining records of software licenses
• Managing stocks of equipment, consumables and other supplies.
• Monitoring and maintaining computer systems and networks;
• Talking staff through a series of actions, either face to face or over the telephone to help set up systems or resolve issues;
• Troubleshooting system and network problems and diagnosing and solving hardware or software faults;
• Replacing parts as required;
• Providing support, including procedural documentation and relevant reports;
• Following diagrams and written instructions to repair a fault or set up a system;
• Supporting the roll-out of new applications;
• Setting up new users' accounts and profiles and dealing with password issues;
• Responding within agreed time limits to call-outs;
• Working continuously on a task until completion (or referral to third parties, if appropriate);
• Prioritizing and managing many open cases at one time;
• Rapidly establishing a good working relationship with users and other professionals, e.g., software developers;
• Testing and evaluating new technology;
• Conducting electrical safety checks on computer equipment.
• Shift and on-call work may be required, particularly where computing equipment is in continual 24-hour operation.

Click here for Apply here :
http://www.naukrigulf.com/job-listings-IT-Support-Executive-Raysut-Salalah-Oman-Dhofar-Cattle-Field-2-to-5-years-230315000009-?xz=&jobId=230315000009&key=&keyar=&loc=oman&exp=&srchRank=1&srchId=142717881192836000&currPage=1&sort=relevance&freshness=&compType=&companyId=&partnercompany=&userSource=