How to use between condition with @prompt function in SAP IDT

[former_member592846]

Hi All,

I have one requirement like user needs to select start date and end date as a prompt. There is filed called Day Full is a date field. I have to create a prompt with start date and end date (Between option). I tired with multiple options but i couldn't find the mistake. Please advise me with format. I have tried with below format

Day_Full between (@Prompt ('Select Day full start date', ' D', 'Table name\Day_Full', Multi, Constrained,Persistent)) AND (@Prompt ('Select Day full end date', ' D', 'Table name\Day_Full', Multi, Constrained,Persistent))

Thanks in advance,

Dhinakaran

[mhmohammed]

Hi D,

Please use Mono, instead of Multi in both the places in the prompt definition you have here.

Day_Full between (@Prompt ('Select Day full start date', ' D', 'Table name\Day_Full', Mono, Constrained,Persistent)) AND (@Prompt ('Select Day full end date', ' D', 'Table name\Day_Full', Mono, Constrained,Persistent))

Thanks,
Mahboob Mohammed

[ayman_salem]

What error message do you have?

[former_member592846]

Hi Salem,

Please find the error screenshot attached.

between.jpg