Logic for date currentdate

Help Studio
, ,
1

i have to check whether today is sat or sunday … if it is sat after 10:30AM i want monday date… if it is below 10:30 i want to put friday date…

  1. if it is sunday… i want monday date
2

Hi @katta_nikhil ,

Can you try this.

str = Now.Tostring("dd-MM-yyyy HHmm")

outputDate = If(DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).ToString("ddd")="Sat",If(
	CInt(DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).ToString("HHmm"))>=1030,
	DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).AddDays(2).ToShortDateString,
	DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToShortDateString),
	If(DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).ToString("ddd")="Sun",
	DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).AddDays(1).ToShortDateString,Nothing))

Thanks!

3

Hi @katta_nikhil

Refer the below Workflow file for the required output.

Sequence6.xaml (12.1 KB)

Hope it helps!!
Regards,

4

CAN U PLEASE recheck and send me… it is not working

5

@katta_nikhil
Is the file not opening for you.
Regards,

6

no it is opening but iam not getting the required output

can u add for today scenerio… becoz today is thursday right … so i want today date

7

@katta_nikhil

If it is saturday it will give you the required output. But today is not saturday right so it won’t print anything.

Regards,

8

yeah , it right but can u add today scenario also … if today is not sat or sunday … then it has to give today date itself

9

Can you try this.

str = Now.Tostring("dd-MM-yyyy HHmm")

outputDate = If(DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).ToString("ddd")="Sat",If(
	CInt(DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).ToString("HHmm"))>=1030,
	DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).AddDays(2).ToShortDateString,
	DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).AddDays(-1).ToShortDateString),
	If(DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).ToString("ddd")="Sun",
	DateTime.ParseExact(str,"dd-MM-yyyy HHmm",system.Globalization.CultureInfo.InvariantCulture).AddDays(1).ToShortDateString,str))

This query will give a today date

Thanks!

10

my senior dev wants only understand logic…

11

@katta_nikhil

try this:

currentDate = DateTime.Now

desiredDate = If(currentDate.DayOfWeek = DayOfWeek.Saturday,
                            If(currentDate.TimeOfDay >= New TimeSpan(10, 30, 0),
                               currentDate.AddDays(2),
                               currentDate.AddDays(-1)
                              ),
                            If(currentDate.DayOfWeek = DayOfWeek.Sunday,
                               currentDate.AddDays(1),
                               Nothing
                              )
                           )

Hope it helps.

12

@katta_nikhil

Use this below condition in the else block

currentDateTime.AddDays(0)

It will give the current date of today.

Note: Shared the workflow for reference
Sequence6.xaml (13.4 KB)

Regards,

13

thank you sooooo muchhh

1 Like
14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.