You need to sign in to do that
Don't have an account?
Milan Hrdlicka
Check if actual time fits in particular time range using datetime field
Hi all,
lets say it's Monday (I have solved this by using particular "Monday" date using datetime field) 10:00 am and I need to check whether this time falls into opening hours which does in below case.
Any suggestion of how to do that? Get actual time and somehow compare whether this falls in between opening and closing hours?
Can this be done by a single SOQL query?
Opening Hours: 2017-01-02T07:30:00.000+0000
Closing Hours: 2017-01-02T19:30:00.000+0000
Appreciate your help on this.
Milan
lets say it's Monday (I have solved this by using particular "Monday" date using datetime field) 10:00 am and I need to check whether this time falls into opening hours which does in below case.
Any suggestion of how to do that? Get actual time and somehow compare whether this falls in between opening and closing hours?
Can this be done by a single SOQL query?
Opening Hours: 2017-01-02T07:30:00.000+0000
Closing Hours: 2017-01-02T19:30:00.000+0000
Appreciate your help on this.
Milan
vaishali sharma
Is this the only format that you are using. The format of opening hours and closing hours.If you can match these format then you can achieve it using SOQL using simply > and < variables.
Milan Hrdlicka
Yes, at the moment the only format I use.