Log in to AnswerLog in to Follow
UserImage.jpg
Rohan Roy
33Views
8Comments
Avoid duplicate data entry
Question
Aggregate
Beginner
Best Practices
Database
Development

Hi guys,

I am having 2 fields,

1) Performance From date

2)Performance To date

Suppose,

Performance From date= 1 Jan 2021

Performance To date= 1 Apr 2021

And If I try to add new record between Performance From date and Performance To date

i.e  Performance From date = 2 Jan 2021 

     Performance To date =2 feb 2021

then it must should my an message.

How can I do this???

See the .oml send an updated .oml

DateRange.oml

0
0
19 Apr

Hi Rohan,

I think it will be a simple check. Like when you entering a new record in database so before entering the record in you can check this condition

NewFromDate>= DatabaseFromDate and NewToDate<= DatabaseToDate. 

Using above you can change that new range is between already given range or not and accordingly you can show the message to user.

Regards

0
0
19 Apr

Hi 

Send me an updated .oml

0
1
19 Apr

Hello Rohan 

Use this in client action you will get the answer

1
0
19 Apr

Hi

Send me an updated .oml

0
1
19 Apr
timedemo.oml

0
0
20 Apr

Replying to Priyanka S's comment on 20 Apr 2022 04:47:38

Hi Priyanka I have see the .oml but it is not working for all the values

Like I want to compare the date of local variable with all the values in database .


0
0
20 Apr

Replying to Rohan Roy's comment on 20 Apr 2022 10:20:16

Hi Rohan 

Would explain me the actual requirement


0
0
20 Apr

hi Rohan

Employee.PerformanceFromDate > Fromdate and Employee.PerformanceEndDate < Todate
use this in search filter you will get the answer
DateRange.oml

1
0
20 Apr
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.