Issue with Makedate function

[Anonymous]

Hello

I have a test data as follows:

DateTest

1/05/2018 03:05:45 a.m

2/05/2018 03:07:55 a.m

3/05/2018 03:30:25 a.m

4/05/2018 03:30:25 a.m

5/05/2018 03:30:25 a.m

6/05/2018 03:30:25 a.m

7/05/2018 03:30:25 a.m

8/05/2018 03:30:25 a.m

9/05/2018 03:30:25 a.m

10/05/2018 03:30:25 a.m

11/05/2018 03:30:25 a.m

12/05/2018 03:30:25 a.m

13/05/2018 03:30:25 a.m

14/05/2018 03:30:25 a.m

15/05/2018 03:30:25 a.m

16/05/2018 03:30:25 a.m

17/05/2018 03:30:25 a.m

18/05/2018 03:30:25 a.m

I am using a code:

Test:

LOAD DateTest,

makedate(Date#(year(DateTest),month(DateTest)),'MM-YYYY') as RevisedDate

FROM

(ooxml, embedded labels, table is Sheet1);

It does not return any output. I also tried running the function without Date#. The same thing happened.

Got a blank listbox in both cases.

Please help.

Regards

Mahendra

[duncanblaine]

You're missing a 'THEN' here:
if '$(SourceTable)' <> '' THEN

[Anonymous]

Anil

None of them are working

Regards

Mahendra

[Anonymous]

Sashidhar

That really worked.

Thanks a lot for your help.

Also can you please let me know if conditional statements can be used in textbox objects?

If you can provide a simple example of it