Date Query

Help Automation Ops
,
1

The date should be the end of the current month but format should be in mmm-yy format and at the end of the month it should give previous month in mmm-yy format. What is the linq query for it.

2

Hi @anjani_priya

Try this

Datee = (If(Now.Day = 1, Now.AddMonths(-1), Now).ToString("MMM-yy"))

The image shows a part of a workflow in which a date value is assigned to the variable "Datee" and then displayed in a message box showing "Feb-25". (Captioned by AI)
The image shows a part of a workflow in which a date value is assigned to the variable "Datee" and then displayed in a message box showing "Feb-25". (Captioned by AI)841×402 18.6 KB

Regards,

1 Like
3

@anjani_priya,

Can you explain the requirement with an example please?

4

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